What is difference between getdate and sysdatetime in sql server 2008?
Explain triggers in sql?
How to select some specific rows from a table in ms sql server?
Write a SQL command to insert and update only a particular field?
What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is a View ? Can we insert, Update and delete a view?
Explain the rules for designing files and file groups in sql server?
what are the critical issues you have resloved in your company
What is named query? : sql server analysis services, ssas
What happens if we shrink log file in sql server?
What is self join in sql server joins?