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: 2506
Types of Views in SQL Server ?
Answer: 1  |  Posted On: 16/12/2014 08:57:46  |  Posted By: Rahul Saxena  |  Viewed: 2412
Can Foreign Key be null ?
Answer: 1  |  Posted On: 23/08/2014 03:39:40  |  Posted By: Kashish  |  Viewed: 1152
Difference between Delete and Truncate
Answer: 2  |  Posted On: 28/02/2014 15:02:42  |  Posted By: Rahul Saxena  |  Viewed: 1682
Delete Duplicate Rows In SQL
Answer: 3  |  Posted On: 28/02/2014 14:58:49  |  Posted By: Rahul Saxena  |  Viewed: 1522
What is the purpose of using SET ANSI NULLS ON?
Answer: 1  |  Posted On: 24/09/2013 09:30:12  |  Posted By: Rahul  |  Viewed: 1448
How would you handle error in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:48:51  |  Posted By: varun  |  Viewed: 1528
What is use of EXCEPT Clause?
Answer: 1  |  Posted On: 30/07/2013 11:47:53  |  Posted By: Rahul  |  Viewed: 1356
What is Isolation Levels?
Answer: 1  |  Posted On: 30/07/2013 11:47:16  |  Posted By: Rahul  |  Viewed: 1340
What are synonyms?
Answer: 1  |  Posted On: 30/07/2013 11:46:29  |  Posted By: Rahul  |  Viewed: 1392
What are the Advantages of using CTE?
Answer: 1  |  Posted On: 30/07/2013 11:44:59  |  Posted By: Rahul  |  Viewed: 1390
Which are new data types introduced in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:44:20  |  Posted By: Rahul  |  Viewed: 1608
What is Filtered Index?
Answer: 1  |  Posted On: 30/07/2013 11:43:26  |  Posted By: sachin  |  Viewed: 1348
What is CTE?
Answer: 1  |  Posted On: 30/07/2013 11:41:51  |  Posted By: sachin  |  Viewed: 1476
What are Sparse Columns?
Answer: 1  |  Posted On: 30/07/2013 11:40:44  |  Posted By: Sara  |  Viewed: 1482
What is Replication and Database Mirroring?
Answer: 1  |  Posted On: 30/07/2013 11:40:17  |  Posted By: Sara  |  Viewed: 1360
What is Service Broker?
Answer: 1  |  Posted On: 30/07/2013 11:39:40  |  Posted By: Sara  |  Viewed: 1290
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: 1336
What is Trigger? What is its use?
Answer: 1  |  Posted On: 25/02/2013 12:27:59  |  Posted By: Rahul  |  Viewed: 1368
What is isolation level?
Answer: 1  |  Posted On: 25/02/2013 12:25:51  |  Posted By: Rahul  |  Viewed: 1800
What are Magic tables in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:23:15  |  Posted By: Rahul  |  Viewed: 1376
What are the recovery models for a database?
Answer: 1  |  Posted On: 25/02/2013 12:17:56  |  Posted By: Sara  |  Viewed: 1402
What is the difference between a Delete and Truncate?
Answer: 1  |  Posted On: 25/02/2013 12:16:11  |  Posted By: Sara  |  Viewed: 1380
How many columns can be created in a single table?
Answer: 1  |  Posted On: 25/02/2013 12:15:10  |  Posted By: Sara  |  Viewed: 1368
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: 1352
What is the difference between Clustered and Non-Clustered Index?
Answer: 1  |  Posted On: 25/02/2013 12:09:47  |  Posted By: Sara  |  Viewed: 1368
What are the different constraints in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:07:19  |  Posted By: Sara  |  Viewed: 1366
Write a SELECT statement without FROM Clause?
Answer: 1  |  Posted On: 25/02/2013 12:05:20  |  Posted By: Sara  |  Viewed: 1586
What is a CTE?
Answer: 1  |  Posted On: 25/02/2013 12:04:39  |  Posted By: Sara  |  Viewed: 1396
New Features of SQL Server 2008 Management Studio
Answer: 1  |  Posted On: 25/02/2013 11:43:07  |  Posted By: Rahul  |  Viewed: 1340
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: 1338
Difference between LINQ and Stored Procedures
Answer: 1  |  Posted On: 23/02/2013 06:14:39  |  Posted By: Rahul  |  Viewed: 1440
Common Table Expressions
Answer: 1  |  Posted On: 23/02/2013 06:10:25  |  Posted By: Rahul  |  Viewed: 1476
Explain Cursor in SQL Server 2008?
Answer: 4  |  Posted On: 29/10/2012 07:15:10  |  Posted By: deepak  |  Viewed: 1496
Difference between union and union all in SQL Server 2008?
Answer: 1  |  Posted On: 29/10/2012 07:12:54  |  Posted By: deepak  |  Viewed: 1392
Primary Key Constraint in Sql Server ..?
Answer: 1  |  Posted On: 29/10/2012 07:09:35  |  Posted By: deepak  |  Viewed: 1354
How to generate GUID In sql Server..?
Answer: 1  |  Posted On: 29/10/2012 07:06:51  |  Posted By: deepak  |  Viewed: 1374
How will retrieve the 2nd highest salary from a table...
Answer: 1  |  Posted On: 05/09/2012 23:20:11  |  Posted By: naman  |  Viewed: 1460
How can you improve SQL Query performance...
Answer: 1  |  Posted On: 03/09/2012 20:20:49  |  Posted By: Rahul  |  Viewed: 1578
SQL LIKE Operator...
Answer: 2  |  Posted On: 20/08/2012 23:42:41  |  Posted By: Ayush  |  Viewed: 2170
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: 1480
What are Pessimistic Lock and Optimistic Lock?
Answer: 1  |  Posted On: 15/08/2012 00:27:14  |  Posted By: sonam  |  Viewed: 1466
What is an SQL Server Agent?
Answer: 1  |  Posted On: 15/08/2012 00:26:39  |  Posted By: sonam  |  Viewed: 1646
What is the difference between UNION and UNION ALL?
Answer: 1  |  Posted On: 15/08/2012 00:25:56  |  Posted By: sonam  |  Viewed: 1474
What is CHECK Constraint?
Answer: 1  |  Posted On: 15/08/2012 00:25:25  |  Posted By: sonam  |  Viewed: 1666
What are Different Types of Locks?
Answer: 1  |  Posted On: 15/08/2012 00:24:36  |  Posted By: sonam  |  Viewed: 1462
What is Dirty Read?
Answer: 1  |  Posted On: 14/08/2012 23:51:01  |  Posted By: sonam  |  Viewed: 1460
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: 1656
What do you mean by Identity in SQL Server?
Answer: 1  |  Posted On: 14/08/2012 23:28:12  |  Posted By: Ayush  |  Viewed: 1448
Explain Primary Keys and Foreign Keys?
Answer: 1  |  Posted On: 14/08/2012 23:27:17  |  Posted By: Ayush  |  Viewed: 1598
Explain JOIN...
Answer: 1  |  Posted On: 14/08/2012 23:26:40  |  Posted By: Ayush  |  Viewed: 1592
What is subquery?
Answer: 1  |  Posted On: 14/08/2012 23:26:10  |  Posted By: Ayush  |  Viewed: 1652
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: 1456
What is a Cursor?
Answer: 1  |  Posted On: 14/08/2012 23:24:58  |  Posted By: Ayush  |  Viewed: 1640
What is a Linked Server?
Answer: 1  |  Posted On: 14/08/2012 23:24:35  |  Posted By: Ayush  |  Viewed: 1542
What is an Index?
Answer: 1  |  Posted On: 14/08/2012 23:24:08  |  Posted By: Ayush  |  Viewed: 1558
What are the Different Types of Triggers?
Answer: 1  |  Posted On: 14/08/2012 23:00:15  |  Posted By: Ayush  |  Viewed: 1554
What is a Trigger?
Answer: 1  |  Posted On: 14/08/2012 22:59:33  |  Posted By: Ayush  |  Viewed: 1495
What is a Stored Procedure?
Answer: 1  |  Posted On: 14/08/2012 22:58:10  |  Posted By: Ayush  |  Viewed: 1462
What is Normalization?
Answer: 0  |  Posted On: 14/08/2012 22:57:37  |  Posted By: Rahul  |  Viewed: 1422
How we can get the full information about a table...
Answer: 2  |  Posted On: 14/08/2012 22:45:11  |  Posted By: Rahul  |  Viewed: 1466
How we can monitor SQL Server performance?
Answer: 0  |  Posted On: 14/08/2012 22:43:23  |  Posted By: Rahul  |  Viewed: 1468
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: 1458
Which TCP/IP port does SQL Server run on?
Answer: 1  |  Posted On: 19/07/2012 13:13:33  |  Posted By: Rahul  |  Viewed: 1474
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us