When to use Inner join & when to use subquery?
Explain the concept of recursive stored procedure.
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Why SQL Agent is used?
What does REVERT do in SQL Server 2005?
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?
15 Answers Leo Technologies, Mannar Company, Synechron,
how can we use a composite key for two tables and how can we represent it
What is user-defined scalar function?
How to see the event list of an existing trigger using sys.trigger_events?
What is importing utility?
What is normalization and what are the different forms of normalizations?
What are the pre-defined functions in the sql server?
How are the unique and primary key constraints different?