What is the difference between DELETE and TRUNCATE?

 Posted by Deepak on 2/5/2009 | Category: Sql Server Interview questions | Views: 4713
Answer:

In TRUNCATE we can not rollback..
In DELETE we can rollback


Asked In: client interview | Alert Moderator 

Comments or Responses

Posted by: Vivekjj on: 10/5/2012 | Points: 10
delete command is used to delete particular records or whole records from the table ,But, truncate command is used to delete whole records from the table

Login to post response

More Interview Questions by Deepak