What is a view in sql?
Why truncate is ddl?
Is Sql non procedural query language?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.
What are the differences between ms sql server & oracle?
What are security principals used in sql server 2005?
What is logon trigger?
What are the difference between primary key and unique key? : sql server database administration
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is resultset concur_updatable?
How will you know when statistics on a table are obsolete?