Wednesday, 30 March 2011

Difference between DELETE and TRUNCATE commands in SQL Server.

DELETE TABLE is a logged operation, it is a slow process.   Delete can be roll back operation
     

TRUNCATE TABLE deletes all the rows, but it won't log the deletion, conquently it is fast process.          
TRUNCATE TABLE  can't be roll back operation

No comments:

Post a Comment