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: 1932
Types of Views in SQL Server ?
Answer: 1  |  Posted On: 16/12/2014 08:57:46  |  Posted By: Rahul Saxena  |  Viewed: 1900
Can Foreign Key be null ?
Answer: 1  |  Posted On: 23/08/2014 03:39:40  |  Posted By: Kashish  |  Viewed: 980
Difference between Delete and Truncate
Answer: 2  |  Posted On: 28/02/2014 15:02:42  |  Posted By: Rahul Saxena  |  Viewed: 1498
Delete Duplicate Rows In SQL
Answer: 3  |  Posted On: 28/02/2014 14:58:49  |  Posted By: Rahul Saxena  |  Viewed: 1344
What is the purpose of using SET ANSI NULLS ON?
Answer: 1  |  Posted On: 24/09/2013 09:30:12  |  Posted By: Rahul  |  Viewed: 1276
How would you handle error in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:48:51  |  Posted By: varun  |  Viewed: 1346
What is use of EXCEPT Clause?
Answer: 1  |  Posted On: 30/07/2013 11:47:53  |  Posted By: Rahul  |  Viewed: 1186
What is Isolation Levels?
Answer: 1  |  Posted On: 30/07/2013 11:47:16  |  Posted By: Rahul  |  Viewed: 1172
What are synonyms?
Answer: 1  |  Posted On: 30/07/2013 11:46:29  |  Posted By: Rahul  |  Viewed: 1218
What are the Advantages of using CTE?
Answer: 1  |  Posted On: 30/07/2013 11:44:59  |  Posted By: Rahul  |  Viewed: 1222
Which are new data types introduced in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:44:20  |  Posted By: Rahul  |  Viewed: 1430
What is Filtered Index?
Answer: 1  |  Posted On: 30/07/2013 11:43:26  |  Posted By: sachin  |  Viewed: 1174
What is CTE?
Answer: 1  |  Posted On: 30/07/2013 11:41:51  |  Posted By: sachin  |  Viewed: 1314
What are Sparse Columns?
Answer: 1  |  Posted On: 30/07/2013 11:40:44  |  Posted By: Sara  |  Viewed: 1320
What is Replication and Database Mirroring?
Answer: 1  |  Posted On: 30/07/2013 11:40:17  |  Posted By: Sara  |  Viewed: 1196
What is Service Broker?
Answer: 1  |  Posted On: 30/07/2013 11:39:40  |  Posted By: Sara  |  Viewed: 1128
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: 1178
What is Trigger? What is its use?
Answer: 1  |  Posted On: 25/02/2013 12:27:59  |  Posted By: Rahul  |  Viewed: 1204
What is isolation level?
Answer: 1  |  Posted On: 25/02/2013 12:25:51  |  Posted By: Rahul  |  Viewed: 1638
What are Magic tables in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:23:15  |  Posted By: Rahul  |  Viewed: 1216
What are the recovery models for a database?
Answer: 1  |  Posted On: 25/02/2013 12:17:56  |  Posted By: Sara  |  Viewed: 1240
What is the difference between a Delete and Truncate?
Answer: 1  |  Posted On: 25/02/2013 12:16:11  |  Posted By: Sara  |  Viewed: 1222
How many columns can be created in a single table?
Answer: 1  |  Posted On: 25/02/2013 12:15:10  |  Posted By: Sara  |  Viewed: 1208
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: 1180
What is the difference between Clustered and Non-Clustered Index?
Answer: 1  |  Posted On: 25/02/2013 12:09:47  |  Posted By: Sara  |  Viewed: 1210
What are the different constraints in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:07:19  |  Posted By: Sara  |  Viewed: 1208
Write a SELECT statement without FROM Clause?
Answer: 1  |  Posted On: 25/02/2013 12:05:20  |  Posted By: Sara  |  Viewed: 1432
What is a CTE?
Answer: 1  |  Posted On: 25/02/2013 12:04:39  |  Posted By: Sara  |  Viewed: 1242
New Features of SQL Server 2008 Management Studio
Answer: 1  |  Posted On: 25/02/2013 11:43:07  |  Posted By: Rahul  |  Viewed: 1184
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: 1180
Difference between LINQ and Stored Procedures
Answer: 1  |  Posted On: 23/02/2013 06:14:39  |  Posted By: Rahul  |  Viewed: 1276
Common Table Expressions
Answer: 1  |  Posted On: 23/02/2013 06:10:25  |  Posted By: Rahul  |  Viewed: 1320
Explain Cursor in SQL Server 2008?
Answer: 4  |  Posted On: 29/10/2012 07:15:10  |  Posted By: deepak  |  Viewed: 1328
Difference between union and union all in SQL Server 2008?
Answer: 1  |  Posted On: 29/10/2012 07:12:54  |  Posted By: deepak  |  Viewed: 1234
Primary Key Constraint in Sql Server ..?
Answer: 1  |  Posted On: 29/10/2012 07:09:35  |  Posted By: deepak  |  Viewed: 1192
How to generate GUID In sql Server..?
Answer: 1  |  Posted On: 29/10/2012 07:06:51  |  Posted By: deepak  |  Viewed: 1220
How will retrieve the 2nd highest salary from a table...
Answer: 1  |  Posted On: 05/09/2012 23:20:11  |  Posted By: naman  |  Viewed: 1302
How can you improve SQL Query performance...
Answer: 1  |  Posted On: 03/09/2012 20:20:49  |  Posted By: Rahul  |  Viewed: 1428
SQL LIKE Operator...
Answer: 2  |  Posted On: 20/08/2012 23:42:41  |  Posted By: Ayush  |  Viewed: 2014
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: 1330
What are Pessimistic Lock and Optimistic Lock?
Answer: 1  |  Posted On: 15/08/2012 00:27:14  |  Posted By: sonam  |  Viewed: 1314
What is an SQL Server Agent?
Answer: 1  |  Posted On: 15/08/2012 00:26:39  |  Posted By: sonam  |  Viewed: 1494
What is the difference between UNION and UNION ALL?
Answer: 1  |  Posted On: 15/08/2012 00:25:56  |  Posted By: sonam  |  Viewed: 1318
What is CHECK Constraint?
Answer: 1  |  Posted On: 15/08/2012 00:25:25  |  Posted By: sonam  |  Viewed: 1508
What are Different Types of Locks?
Answer: 1  |  Posted On: 15/08/2012 00:24:36  |  Posted By: sonam  |  Viewed: 1304
What is Dirty Read?
Answer: 1  |  Posted On: 14/08/2012 23:51:01  |  Posted By: sonam  |  Viewed: 1306
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: 1500
What do you mean by Identity in SQL Server?
Answer: 1  |  Posted On: 14/08/2012 23:28:12  |  Posted By: Ayush  |  Viewed: 1300
Explain Primary Keys and Foreign Keys?
Answer: 1  |  Posted On: 14/08/2012 23:27:17  |  Posted By: Ayush  |  Viewed: 1444
Explain JOIN...
Answer: 1  |  Posted On: 14/08/2012 23:26:40  |  Posted By: Ayush  |  Viewed: 1442
What is subquery?
Answer: 1  |  Posted On: 14/08/2012 23:26:10  |  Posted By: Ayush  |  Viewed: 1502
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: 1304
What is a Cursor?
Answer: 1  |  Posted On: 14/08/2012 23:24:58  |  Posted By: Ayush  |  Viewed: 1488
What is a Linked Server?
Answer: 1  |  Posted On: 14/08/2012 23:24:35  |  Posted By: Ayush  |  Viewed: 1390
What is an Index?
Answer: 1  |  Posted On: 14/08/2012 23:24:08  |  Posted By: Ayush  |  Viewed: 1408
What are the Different Types of Triggers?
Answer: 1  |  Posted On: 14/08/2012 23:00:15  |  Posted By: Ayush  |  Viewed: 1400
What is a Trigger?
Answer: 1  |  Posted On: 14/08/2012 22:59:33  |  Posted By: Ayush  |  Viewed: 1343
What is a Stored Procedure?
Answer: 1  |  Posted On: 14/08/2012 22:58:10  |  Posted By: Ayush  |  Viewed: 1308
What is Normalization?
Answer: 0  |  Posted On: 14/08/2012 22:57:37  |  Posted By: Rahul  |  Viewed: 1266
How we can get the full information about a table...
Answer: 2  |  Posted On: 14/08/2012 22:45:11  |  Posted By: Rahul  |  Viewed: 1312
How we can monitor SQL Server performance?
Answer: 0  |  Posted On: 14/08/2012 22:43:23  |  Posted By: Rahul  |  Viewed: 1312
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: 1306
Which TCP/IP port does SQL Server run on?
Answer: 1  |  Posted On: 19/07/2012 13:13:33  |  Posted By: Rahul  |  Viewed: 1312
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us