Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Difference between Truncate and Delete

    QUESTION

    Is "TRUNCATE" and "ROLLBACK" reliable?

    If TRUNCATE de-allocates the pages, which can be overwritten by subsequent operations, can the ROLLBACK of a TRUNCATE operation restore the original data?

    Eg.

    BEGIN TRANSACTION

    ..

    TRUNCATE table1

    ..

    insert to...

Viewing post 1 (of 1 total)