What is difference between drop truncate and delete?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,


What is Inner Join?

2 Answers  


Explain various data region available in ssrs with their use?

0 Answers  


How many categories of functions based their return modes?

0 Answers  


explain different types of cursors? : Sql server database administration

0 Answers  






What is bcp? When does it used?

0 Answers  


How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  


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?

0 Answers  


What is the return type of executeupdate ()?

0 Answers  


How to find the service pack installed? : sql server database administration

0 Answers  


What is the order in which the sql query is executed?

0 Answers  


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,


Categories