Home Forums Article Discussions Article Discussions by Author Discuss content posted by Prashant Pandey The Difference between Truncate and Delete in SQL Server RE: Difference between Truncate and Delete

  • July 7, 2011 at 8:01 am

    #1349722

    virat_108 (4/14/2011)

    You will get better and easy explanation over here:

    http://dotnetpeoples.blogspot.com/2011/04/difference-between-delete-and-truncate.html

    That blog post states that delete cannot be rolled back. This is inaccurate. Both truncate and delete can be rolled back if they are within a begin tran/commit/rollback statement.