Explain sql delete command?
How can you list all the columns in a database?
What options are available to audit login activity? : sql server security
how to use DTS package in 2000,2005,2008 in sql server
Explain “row_number()” in sql server with an example?
Write a query for primary key constraint with identity key word?
How to create nested stored procedure?
What is the fastest way to permanently delete a 1 million row table named customers?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Is it possible to create trigger on views?
What are Row versions of DataRow?
Define Unique Key?
What is sub-query in sql server? Explain its properties.