Dinesh Beniwal
Can you tell me the difference between DELETE & TRUNCATE commands?
Posted by Dinesh Beniwal in SQL Server on Jul 15, 2006
  • 0
  • 2
  • 7809
Do you know the answer for this question? Post it below.
Guest
Posted by raemz on Aug 25, 2006
  • 0

Hi Praveen,



TRUNCATE is also rollback the data.But difference is TRUNCATE can't mantian the log.



 

Posted by pravs on Jul 24, 2006
  • 0

TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. 
DELETE is a DML command and can be rolled back. 
 
Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.



More info at :



http://www.faqfarm.com/Q/How_do_you_differentiate_between_truncate_and_delete



http://www.geekinterview.com/question_details/425



 


Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS

PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | ABOUT US | REPORT ABUSE
2014© C# Corner. All contents are copyright of their authors.