Write a query for primary key constraint with identity key word?
Can we return Data from 4(more than 1) tables in stored procedure?
Define Joins?
Suggest a method of joining two tables.
Give me any three differences between Truncate and Delete.
What are the types of lock supported by ?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is the difference between Stored Procedures and triggers?
How to update muliple row in single query?
Tell me about the approaches which you used to counter the DI problems.
What is nolock hint in sql server 2008
What is normalization? Explain its different types?
Different types of keys in SQL?
What are Spatial data types in SQL Server 2008
Give main differences between "Truncate" and "Delete".