What is the difference between function and stored procedure in sql server?
How to override dml statements with triggers?
How to insert multiple rows with a subquery?
What is a field in a table?
What is the difference between for auto and for nested?
How will you hide an attribute? : sql server analysis services, ssas
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Why we use functions in sql server?
What are transactions in sql?
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
Explain Geometry datatype in sql server 2008 with example
What is difference between drop truncate and delete?
What is the difference between rank and dense_rank?