Basic SQL Server Interview Questions
- What are the different types of replication supported by SQL SERVER?
- What is BCP utility in SQL SERVER?
- What are the different types of triggers in SQl SERVER?
- If we have multiple AFTER Triggers on table how can we define the sequence of the triggers?
- What is SQL injection?
- What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
What are advantages of SQL 2000 over SQl 7.0?
Answer
Locking in SQL SERVER
- What suggest locking hints to SQL SERVER?
- What is LOCK escalation?
- What are the different ways of moving data between databases in SQL Server?Describe different kind of locks in SQL SERVER?
