How to insert multiple rows with one insert statement in ms sql server?
What does executeupdate return?
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
How many types of schemas are there?
Can a unique index be created on a column, which contains null?
please differentiate between delete and truncate?
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM
Anyone please explain me the concept of Serialization?
what is a self join? Explain it with an example? : Sql server database administration
Determine when an index is appropriate?
What are the restraints imposed on the table design by a merge replication?
Does sql server 2000 clustering support load balancing?
What is difference between join and natural join?