Home Forums Article Discussions Article Discussions by Author Discuss content posted by Craig Farrell TRUNCATE TABLE and ROLLBACK TRAN RE: TRUNCATE TABLE and ROLLBACK TRAN

  • February 6, 2012 at 2:02 am

    #1442940

    CREATE TABLE t(id INT IDENTITY, i INT)

    BEGIN TRAN

    INSERT INTO t VALUES (4),(2),(3)

    SELECT * FROM t

    ROLLBACK TRAN

    SELECT * FROM t

    INSERT INTO t VALUES (4),(2),(3)

    SELECT * FROM t

    where is rollback?