SQL Server Interview Questions

1. What's magic table
2. Find the Duplicate rows
3. Delete the Duplicate rows 2nd duplicate rows on wards
4. Difference between procedure and function
5. How to view your stored procedure code
6. Can i give alias name in order by clause
7. How can i give sort column while you are using union all sets data
8. What's the sequence of execution Select statement to order by clause
9. How many clustered indexes will have one table?
10. How many non clustered indexes can create for a table?
11. What you can see in the execution plan?
12. Which one faster Index seek/Index scan/ Table scan?
13. What's the purpose of Identity?
14. What's Merge ?
15. How do you find the indexes ?
16. How do you handle exceptions?
17. How do you encrypt the stored procedure instead of viewing entire code?
18. What's read_commited_snapshot ?
19. How do you read a file stored as a column by using T-SQL query?
20. What are the locks ?