Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
Help Board:: By Technology
LEFT OUTER JOIN to a MIN/MAX row
Answer: 0  |  Posted On: 24/12/2014 20:02:59  |  Posted By: Rahul Saxena  |  Viewed: 1860
Types of Views in SQL Server ?
Answer: 1  |  Posted On: 16/12/2014 08:57:46  |  Posted By: Rahul Saxena  |  Viewed: 1814
Can Foreign Key be null ?
Answer: 1  |  Posted On: 23/08/2014 03:39:40  |  Posted By: Kashish  |  Viewed: 960
Difference between Delete and Truncate
Answer: 2  |  Posted On: 28/02/2014 15:02:42  |  Posted By: Rahul Saxena  |  Viewed: 1474
Delete Duplicate Rows In SQL
Answer: 3  |  Posted On: 28/02/2014 14:58:49  |  Posted By: Rahul Saxena  |  Viewed: 1324
What is the purpose of using SET ANSI NULLS ON?
Answer: 1  |  Posted On: 24/09/2013 09:30:12  |  Posted By: Rahul  |  Viewed: 1254
How would you handle error in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:48:51  |  Posted By: varun  |  Viewed: 1322
What is use of EXCEPT Clause?
Answer: 1  |  Posted On: 30/07/2013 11:47:53  |  Posted By: Rahul  |  Viewed: 1162
What is Isolation Levels?
Answer: 1  |  Posted On: 30/07/2013 11:47:16  |  Posted By: Rahul  |  Viewed: 1150
What are synonyms?
Answer: 1  |  Posted On: 30/07/2013 11:46:29  |  Posted By: Rahul  |  Viewed: 1196
What are the Advantages of using CTE?
Answer: 1  |  Posted On: 30/07/2013 11:44:59  |  Posted By: Rahul  |  Viewed: 1200
Which are new data types introduced in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:44:20  |  Posted By: Rahul  |  Viewed: 1406
What is Filtered Index?
Answer: 1  |  Posted On: 30/07/2013 11:43:26  |  Posted By: sachin  |  Viewed: 1150
What is CTE?
Answer: 1  |  Posted On: 30/07/2013 11:41:51  |  Posted By: sachin  |  Viewed: 1294
What are Sparse Columns?
Answer: 1  |  Posted On: 30/07/2013 11:40:44  |  Posted By: Sara  |  Viewed: 1298
What is Replication and Database Mirroring?
Answer: 1  |  Posted On: 30/07/2013 11:40:17  |  Posted By: Sara  |  Viewed: 1174
What is Service Broker?
Answer: 1  |  Posted On: 30/07/2013 11:39:40  |  Posted By: Sara  |  Viewed: 1106
What are the basic functions for master, msdb, model, tempdb and resource databases?
Answer: 1  |  Posted On: 30/07/2013 11:37:36  |  Posted By: Rahul  |  Viewed: 1152
What is Trigger? What is its use?
Answer: 1  |  Posted On: 25/02/2013 12:27:59  |  Posted By: Rahul  |  Viewed: 1182
What is isolation level?
Answer: 1  |  Posted On: 25/02/2013 12:25:51  |  Posted By: Rahul  |  Viewed: 1614
What are Magic tables in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:23:15  |  Posted By: Rahul  |  Viewed: 1192
What are the recovery models for a database?
Answer: 1  |  Posted On: 25/02/2013 12:17:56  |  Posted By: Sara  |  Viewed: 1218
What is the difference between a Delete and Truncate?
Answer: 1  |  Posted On: 25/02/2013 12:16:11  |  Posted By: Sara  |  Viewed: 1198
How many columns can be created in a single table?
Answer: 1  |  Posted On: 25/02/2013 12:15:10  |  Posted By: Sara  |  Viewed: 1188
How many Clustered and Non-Clustered Indexes can be created on a single table?
Answer: 1  |  Posted On: 25/02/2013 12:13:44  |  Posted By: Sara  |  Viewed: 1156
What is the difference between Clustered and Non-Clustered Index?
Answer: 1  |  Posted On: 25/02/2013 12:09:47  |  Posted By: Sara  |  Viewed: 1188
What are the different constraints in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:07:19  |  Posted By: Sara  |  Viewed: 1186
Write a SELECT statement without FROM Clause?
Answer: 1  |  Posted On: 25/02/2013 12:05:20  |  Posted By: Sara  |  Viewed: 1408
What is a CTE?
Answer: 1  |  Posted On: 25/02/2013 12:04:39  |  Posted By: Sara  |  Viewed: 1220
New Features of SQL Server 2008 Management Studio
Answer: 1  |  Posted On: 25/02/2013 11:43:07  |  Posted By: Rahul  |  Viewed: 1162
What are the basic functions for master, msdb, model, tempdb and resource databases?
Answer: 1  |  Posted On: 25/02/2013 11:37:50  |  Posted By: Rahul  |  Viewed: 1160
Difference between LINQ and Stored Procedures
Answer: 1  |  Posted On: 23/02/2013 06:14:39  |  Posted By: Rahul  |  Viewed: 1248
Common Table Expressions
Answer: 1  |  Posted On: 23/02/2013 06:10:25  |  Posted By: Rahul  |  Viewed: 1296
Explain Cursor in SQL Server 2008?
Answer: 4  |  Posted On: 29/10/2012 07:15:10  |  Posted By: deepak  |  Viewed: 1304
Difference between union and union all in SQL Server 2008?
Answer: 1  |  Posted On: 29/10/2012 07:12:54  |  Posted By: deepak  |  Viewed: 1212
Primary Key Constraint in Sql Server ..?
Answer: 1  |  Posted On: 29/10/2012 07:09:35  |  Posted By: deepak  |  Viewed: 1168
How to generate GUID In sql Server..?
Answer: 1  |  Posted On: 29/10/2012 07:06:51  |  Posted By: deepak  |  Viewed: 1198
How will retrieve the 2nd highest salary from a table...
Answer: 1  |  Posted On: 05/09/2012 23:20:11  |  Posted By: naman  |  Viewed: 1282
How can you improve SQL Query performance...
Answer: 1  |  Posted On: 03/09/2012 20:20:49  |  Posted By: Rahul  |  Viewed: 1404
SQL LIKE Operator...
Answer: 2  |  Posted On: 20/08/2012 23:42:41  |  Posted By: Ayush  |  Viewed: 1990
What is the Difference between a HAVING clause and a WHERE clause?
Answer: 1  |  Posted On: 15/08/2012 00:27:58  |  Posted By: Rahul  |  Viewed: 1310
What are Pessimistic Lock and Optimistic Lock?
Answer: 1  |  Posted On: 15/08/2012 00:27:14  |  Posted By: sonam  |  Viewed: 1294
What is an SQL Server Agent?
Answer: 1  |  Posted On: 15/08/2012 00:26:39  |  Posted By: sonam  |  Viewed: 1470
What is the difference between UNION and UNION ALL?
Answer: 1  |  Posted On: 15/08/2012 00:25:56  |  Posted By: sonam  |  Viewed: 1296
What is CHECK Constraint?
Answer: 1  |  Posted On: 15/08/2012 00:25:25  |  Posted By: sonam  |  Viewed: 1484
What are Different Types of Locks?
Answer: 1  |  Posted On: 15/08/2012 00:24:36  |  Posted By: sonam  |  Viewed: 1284
What is Dirty Read?
Answer: 1  |  Posted On: 14/08/2012 23:51:01  |  Posted By: sonam  |  Viewed: 1282
What is the Correct Order of the Logical Query Processing Phases?
Answer: 1  |  Posted On: 14/08/2012 23:50:24  |  Posted By: sonam  |  Viewed: 1478
What do you mean by Identity in SQL Server?
Answer: 1  |  Posted On: 14/08/2012 23:28:12  |  Posted By: Ayush  |  Viewed: 1276
Explain Primary Keys and Foreign Keys?
Answer: 1  |  Posted On: 14/08/2012 23:27:17  |  Posted By: Ayush  |  Viewed: 1420
Explain JOIN...
Answer: 1  |  Posted On: 14/08/2012 23:26:40  |  Posted By: Ayush  |  Viewed: 1420
What is subquery?
Answer: 1  |  Posted On: 14/08/2012 23:26:10  |  Posted By: Ayush  |  Viewed: 1480
What is the Difference between a Function and a Stored Procedure?
Answer: 1  |  Posted On: 14/08/2012 23:25:46  |  Posted By: Ayush  |  Viewed: 1282
What is a Cursor?
Answer: 1  |  Posted On: 14/08/2012 23:24:58  |  Posted By: Ayush  |  Viewed: 1468
What is a Linked Server?
Answer: 1  |  Posted On: 14/08/2012 23:24:35  |  Posted By: Ayush  |  Viewed: 1366
What is an Index?
Answer: 1  |  Posted On: 14/08/2012 23:24:08  |  Posted By: Ayush  |  Viewed: 1386
What are the Different Types of Triggers?
Answer: 1  |  Posted On: 14/08/2012 23:00:15  |  Posted By: Ayush  |  Viewed: 1378
What is a Trigger?
Answer: 1  |  Posted On: 14/08/2012 22:59:33  |  Posted By: Ayush  |  Viewed: 1321
What is a Stored Procedure?
Answer: 1  |  Posted On: 14/08/2012 22:58:10  |  Posted By: Ayush  |  Viewed: 1286
What is Normalization?
Answer: 0  |  Posted On: 14/08/2012 22:57:37  |  Posted By: Rahul  |  Viewed: 1244
How we can get the full information about a table...
Answer: 2  |  Posted On: 14/08/2012 22:45:11  |  Posted By: Rahul  |  Viewed: 1290
How we can monitor SQL Server performance?
Answer: 0  |  Posted On: 14/08/2012 22:43:23  |  Posted By: Rahul  |  Viewed: 1288
ow do I get a list of SQL Server tables and their row counts?
Answer: 2  |  Posted On: 14/08/2012 22:41:33  |  Posted By: Rahul  |  Viewed: 1284
Which TCP/IP port does SQL Server run on?
Answer: 1  |  Posted On: 19/07/2012 13:13:33  |  Posted By: Rahul  |  Viewed: 1292
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us