Explain triggers?
What do you mean by sql server 2005 express management tools?
What does the automatic recovery do?
Define Unique Key?
Can we rewrite subqueries into simple select statements or with joins? Example?
What are different types of join?
Can another user execute your local temporary stored procedures?
What is self contained sub query?
What is history table in sql server?
how to find nth highest salary
103 Answers Cognizant, IBM, NexGen, Oracle,
if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are the different index configurations a table can have?