Give me any three differences between Truncate and Delete.


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

Post New Answer

More SQL Server Interview Questions

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  


how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,


i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  


What do you mean by sql server 2005 express management tools?

0 Answers  


what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,






How to use union to merge outputs from two queries together in ms sql server?

0 Answers  


How to transfer Logins from SQL Server 2000 to 2005

2 Answers  


Is it safe to delete log files?

0 Answers  


sql server architecture ?

0 Answers  


How to provide default values to stored procedure parameters?

0 Answers  


what is the difference between table and view

1 Answers  


Why truncate is ddl?

0 Answers  


Categories