Explain user defined functions?
What is BLOCK statements in SQL?
Explain the disadvantages of cursors?
How to select some specific columns from a table in a query in ms sql server?
Explain for xml explicit mode?
What are the tool windows in sql server management studio? : sql server management studio
How can you append an identity column to a temporary table?
What is the recovery model? List the types of recovery model available in sql server?
How many types of keys are there?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Ms sql server index?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What are subquery and its properties?