What is difference between drop truncate and delete?
How can you tell if a database object is invalid?
What is Inner Join?
Explain various data region available in ssrs with their use?
How many categories of functions based their return modes?
explain different types of cursors? : Sql server database administration
What is bcp? When does it used?
How will you add a dimension to cube? : sql server analysis services, ssas
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is the return type of executeupdate ()?
How to find the service pack installed? : sql server database administration
What is the order in which the sql query is executed?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?