Sql Server Interview faqs, question answers



Click the following link(s) to view/answer Sql Server Interview faqs, question answers.
What is a NOLOCK in Sql Server?
1 answer(s) | 836 Views | Tags: Sql Server Interview, Database | Asked By: manish

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

What is data integrity? Explain constraints?
1 answer(s) | 756 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) | 476 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) | 927 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) | 750 Views | Tags: Sql Server Interview, Database | Asked By: Gourav

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

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

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

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

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

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

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

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

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