What is user defined datatypes and when you should go for them?
To find second largest salary in Employee table
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How to search for a string in all stored procedure in sql server?
What is the contrast amongst drop and truncate?
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?
what is diffence between replicaion and logshipping?
Explain system rowset functions?
How to get a list of columns in a view using the "sp_help" stored procedure?
How will you find out if there are expensive SQL statements running or not?
Security Question- SQL DBA exparts, need your help...
What are the requirements on sql server network connections?
How can you see what type of locks used?