Sql Server faqs, question answers

Click the following link(s) to view/answer Sql Server faqs, question answers.

What is a NOLOCK in Sql Server?
1 answer(s) | 873 Views | Tags: Sql Server Interview, Database | Asked By: manish

What is sub-query? Explain properties of sub-query.
1 answer(s) | 735 Views | Tags: Sql Server Interview, Database | Asked By: jack

What is data integrity? Explain constraints?
1 answer(s) | 783 Views | Tags: Sql Server Interview, Database, Sql Server Constraints | Asked By: jack

What are the difference between clustered and a non clustered index?
1 answer(s) | 489 Views | Tags: Sql Server Interview, Database, Sql Server Indexes | Asked By: kethlin

What are different Types of Join we use in Sql Server?
1 answer(s) | 961 Views | Tags: Sql Server Interview, Database, Sql Server Joins | Asked By: kethlin

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
1 answer(s) | 781 Views | Tags: Sql Server Interview, Database | Asked By: Gourav

What is difference between DELETE & TRUNCATE commands?
1 answer(s) | 545 Views | Tags: Sql Server Interview, Database | Asked By: manish

What are the advantages of using Stored Procedures?
1 answer(s) | 438 Views | Tags: Sql Server Interview, Database | Asked By: manish

What is an execution plan? When would you use it?
1 answer(s) | 422 Views | Tags: Sql Server Interview, Database | Asked By: Gourav

How to get @@ERROR and @@ROWCOUNT at the same time?
1 answer(s) | 541 Views | Tags: Sql Server Interview | Asked By: kethlin

What is Difference between Function and Stored Procedure?
1 answer(s) | 383 Views | Tags: Sql Server Interview | Asked By: kethlin

What is Cursor in Sql Server?
1 answer(s) | 392 Views | Tags: Sql Server Interview | Asked By: kethlin

What is Index in Sql Server?
1 answer(s) | 492 Views | Tags: Sql Server Interview | Asked By: kethlin

What is View in Sql Server?
1 answer(s) | 438 Views | Tags: Sql Server Interview | Asked By: kethlin

What is Trigger?
1 answer(s) | 397 Views | Tags: Sql Server Interview | Asked By: kethlin