How to delete all rows with truncate table statement in ms sql server?
Explain collation?
what are cursors? : Sql server database administration
How to handle error or exception in sql?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.
What is the return type of executeupdate ()?
What is sql service broker?
How to create and drop temp table in sql server?
How to delete the duplicate rows from a table in SQL Server ??
How to create a new login name in ms sql server?
how we can store the value like that 001,003,023 etc in sql server 2005
What is an execution plan? When would you use it?