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: 2650
Types of Views in SQL Server ?
Answer: 1  |  Posted On: 16/12/2014 08:57:46  |  Posted By: Rahul Saxena  |  Viewed: 2578
Can Foreign Key be null ?
Answer: 1  |  Posted On: 23/08/2014 03:39:40  |  Posted By: Kashish  |  Viewed: 1200
Difference between Delete and Truncate
Answer: 2  |  Posted On: 28/02/2014 15:02:42  |  Posted By: Rahul Saxena  |  Viewed: 1754
Delete Duplicate Rows In SQL
Answer: 3  |  Posted On: 28/02/2014 14:58:49  |  Posted By: Rahul Saxena  |  Viewed: 1580
What is the purpose of using SET ANSI NULLS ON?
Answer: 1  |  Posted On: 24/09/2013 09:30:12  |  Posted By: Rahul  |  Viewed: 1502
How would you handle error in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:48:51  |  Posted By: varun  |  Viewed: 1570
What is use of EXCEPT Clause?
Answer: 1  |  Posted On: 30/07/2013 11:47:53  |  Posted By: Rahul  |  Viewed: 1404
What is Isolation Levels?
Answer: 1  |  Posted On: 30/07/2013 11:47:16  |  Posted By: Rahul  |  Viewed: 1398
What are synonyms?
Answer: 1  |  Posted On: 30/07/2013 11:46:29  |  Posted By: Rahul  |  Viewed: 1436
What are the Advantages of using CTE?
Answer: 1  |  Posted On: 30/07/2013 11:44:59  |  Posted By: Rahul  |  Viewed: 1448
Which are new data types introduced in SQL SERVER 2008?
Answer: 1  |  Posted On: 30/07/2013 11:44:20  |  Posted By: Rahul  |  Viewed: 1656
What is Filtered Index?
Answer: 1  |  Posted On: 30/07/2013 11:43:26  |  Posted By: sachin  |  Viewed: 1402
What is CTE?
Answer: 1  |  Posted On: 30/07/2013 11:41:51  |  Posted By: sachin  |  Viewed: 1530
What are Sparse Columns?
Answer: 1  |  Posted On: 30/07/2013 11:40:44  |  Posted By: Sara  |  Viewed: 1542
What is Replication and Database Mirroring?
Answer: 1  |  Posted On: 30/07/2013 11:40:17  |  Posted By: Sara  |  Viewed: 1396
What is Service Broker?
Answer: 1  |  Posted On: 30/07/2013 11:39:40  |  Posted By: Sara  |  Viewed: 1340
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: 1388
What is Trigger? What is its use?
Answer: 1  |  Posted On: 25/02/2013 12:27:59  |  Posted By: Rahul  |  Viewed: 1414
What is isolation level?
Answer: 1  |  Posted On: 25/02/2013 12:25:51  |  Posted By: Rahul  |  Viewed: 1858
What are Magic tables in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:23:15  |  Posted By: Rahul  |  Viewed: 1422
What are the recovery models for a database?
Answer: 1  |  Posted On: 25/02/2013 12:17:56  |  Posted By: Sara  |  Viewed: 1464
What is the difference between a Delete and Truncate?
Answer: 1  |  Posted On: 25/02/2013 12:16:11  |  Posted By: Sara  |  Viewed: 1424
How many columns can be created in a single table?
Answer: 1  |  Posted On: 25/02/2013 12:15:10  |  Posted By: Sara  |  Viewed: 1416
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: 1406
What is the difference between Clustered and Non-Clustered Index?
Answer: 1  |  Posted On: 25/02/2013 12:09:47  |  Posted By: Sara  |  Viewed: 1418
What are the different constraints in SQL Server?
Answer: 1  |  Posted On: 25/02/2013 12:07:19  |  Posted By: Sara  |  Viewed: 1416
Write a SELECT statement without FROM Clause?
Answer: 1  |  Posted On: 25/02/2013 12:05:20  |  Posted By: Sara  |  Viewed: 1618
What is a CTE?
Answer: 1  |  Posted On: 25/02/2013 12:04:39  |  Posted By: Sara  |  Viewed: 1446
New Features of SQL Server 2008 Management Studio
Answer: 1  |  Posted On: 25/02/2013 11:43:07  |  Posted By: Rahul  |  Viewed: 1388
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: 1380
Difference between LINQ and Stored Procedures
Answer: 1  |  Posted On: 23/02/2013 06:14:39  |  Posted By: Rahul  |  Viewed: 1484
Common Table Expressions
Answer: 1  |  Posted On: 23/02/2013 06:10:25  |  Posted By: Rahul  |  Viewed: 1524
Explain Cursor in SQL Server 2008?
Answer: 4  |  Posted On: 29/10/2012 07:15:10  |  Posted By: deepak  |  Viewed: 1532
Difference between union and union all in SQL Server 2008?
Answer: 1  |  Posted On: 29/10/2012 07:12:54  |  Posted By: deepak  |  Viewed: 1428
Primary Key Constraint in Sql Server ..?
Answer: 1  |  Posted On: 29/10/2012 07:09:35  |  Posted By: deepak  |  Viewed: 1390
How to generate GUID In sql Server..?
Answer: 1  |  Posted On: 29/10/2012 07:06:51  |  Posted By: deepak  |  Viewed: 1416
How will retrieve the 2nd highest salary from a table...
Answer: 1  |  Posted On: 05/09/2012 23:20:11  |  Posted By: naman  |  Viewed: 1496
How can you improve SQL Query performance...
Answer: 1  |  Posted On: 03/09/2012 20:20:49  |  Posted By: Rahul  |  Viewed: 1612
SQL LIKE Operator...
Answer: 2  |  Posted On: 20/08/2012 23:42:41  |  Posted By: Ayush  |  Viewed: 2214
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: 1528
What are Pessimistic Lock and Optimistic Lock?
Answer: 1  |  Posted On: 15/08/2012 00:27:14  |  Posted By: sonam  |  Viewed: 1498
What is an SQL Server Agent?
Answer: 1  |  Posted On: 15/08/2012 00:26:39  |  Posted By: sonam  |  Viewed: 1680
What is the difference between UNION and UNION ALL?
Answer: 1  |  Posted On: 15/08/2012 00:25:56  |  Posted By: sonam  |  Viewed: 1520
What is CHECK Constraint?
Answer: 1  |  Posted On: 15/08/2012 00:25:25  |  Posted By: sonam  |  Viewed: 1702
What are Different Types of Locks?
Answer: 1  |  Posted On: 15/08/2012 00:24:36  |  Posted By: sonam  |  Viewed: 1506
What is Dirty Read?
Answer: 1  |  Posted On: 14/08/2012 23:51:01  |  Posted By: sonam  |  Viewed: 1496
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: 1690
What do you mean by Identity in SQL Server?
Answer: 1  |  Posted On: 14/08/2012 23:28:12  |  Posted By: Ayush  |  Viewed: 1500
Explain Primary Keys and Foreign Keys?
Answer: 1  |  Posted On: 14/08/2012 23:27:17  |  Posted By: Ayush  |  Viewed: 1640
Explain JOIN...
Answer: 1  |  Posted On: 14/08/2012 23:26:40  |  Posted By: Ayush  |  Viewed: 1626
What is subquery?
Answer: 1  |  Posted On: 14/08/2012 23:26:10  |  Posted By: Ayush  |  Viewed: 1686
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: 1490
What is a Cursor?
Answer: 1  |  Posted On: 14/08/2012 23:24:58  |  Posted By: Ayush  |  Viewed: 1682
What is a Linked Server?
Answer: 1  |  Posted On: 14/08/2012 23:24:35  |  Posted By: Ayush  |  Viewed: 1576
What is an Index?
Answer: 1  |  Posted On: 14/08/2012 23:24:08  |  Posted By: Ayush  |  Viewed: 1604
What are the Different Types of Triggers?
Answer: 1  |  Posted On: 14/08/2012 23:00:15  |  Posted By: Ayush  |  Viewed: 1592
What is a Trigger?
Answer: 1  |  Posted On: 14/08/2012 22:59:33  |  Posted By: Ayush  |  Viewed: 1527
What is a Stored Procedure?
Answer: 1  |  Posted On: 14/08/2012 22:58:10  |  Posted By: Ayush  |  Viewed: 1496
What is Normalization?
Answer: 0  |  Posted On: 14/08/2012 22:57:37  |  Posted By: Rahul  |  Viewed: 1468
How we can get the full information about a table...
Answer: 2  |  Posted On: 14/08/2012 22:45:11  |  Posted By: Rahul  |  Viewed: 1508
How we can monitor SQL Server performance?
Answer: 0  |  Posted On: 14/08/2012 22:43:23  |  Posted By: Rahul  |  Viewed: 1510
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: 1490
Which TCP/IP port does SQL Server run on?
Answer: 1  |  Posted On: 19/07/2012 13:13:33  |  Posted By: Rahul  |  Viewed: 1510
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us