SQL SERVER [23]

SQL SERVER Interview Questions

1. What is a constraint in Sql Server and explain different types of constraints?
2. Difference between unique key and primary key?
3. What is JOINS in SQL SERVER and Different types of JOINS in SQL Server ? 
4. Explain INNER JOIN with an Example? 
5. Explian RIGHT OUTER JOIN with an Example? 
6. Explain LEFT OUTER JOIN with an example?
7. FULL OUTER JOIN Example in SQL SERVER 2005?
8. CROSS JOIN Example in SQL SERVER 2005? 
9. Explain SELF JOIN with an example and give a scenario where it will be useful?
10. Difference between UNION and UNION ALL in SQL SERVER?
11. Stored procedure in SQL SERVER and Advantage of using stored procedure in SQL SERVER?
12. What is an advantage of stored procedure over query in SQL SERVER 2005?
13. Difference between function and stored porcedure in SQL SERVER?
14. Triggers in SQL SERVER and Types of Trigges in SQL SERVER?
15. What is an After Triggers in SQL SERVER 2005 and write down the syntax?
16. What is a Instead Of Triggers in SQL SERVER 2005 and write down the syntax?
17. Can we disable all the triggers on particular table?
18. Is it possible to disable perticular trigger on a table?
19. How can we view all the triggers in a table?
20. Transactions in SQL SERVER 2005?
21. What is @@ERROR variable in SQL SERVER 2005 ?
22. What are different types of transactions in SQL SERVER ?
23. How to return the identity value for an inserted row in SQL SERVER?