Explain identity in sql server?
Explain about Normalization?
What are alternate keys?
What is data source in connection string?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
what is DTS what are tasks available
Explain the truncate command?
How will u test the stroded procedures and functions? difference between SP and Triggers
How can we determine what objects a user-defined function depends upon?
How to insert multiple rows with a subquery?
What is the order in which the SQL query is executed? list them in order.
5 Answers CarrizalSoft Technologies, CTS, Oracle,
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
How to get last system shutdown time in Sql server when restarted system?