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

  • November 22, 2007 at 7:27 am

    #753407

    Jai Kumar (11/22/2007)

    Good one. Before reading this article I my idea was that there is no logging for TRUNCATE tables.

    Thanks.

    One question from my side

    Is this article is applicable for both SQL 2000 and SQL 2005? Or only for SQL 2005?

    Hi Jai,

    This article is applicable to both SQL 2000 and 2005 caz there is no difference between SQL 2000 and SQL 2005 Regarding these TRUNCATE and DELETE commands.:)

    Thanks,
    Prashant