Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nakul Vachhrajani Fun with Transactions - Part III RE: Fun with Transactions - Part III

  • September 21, 2010 at 12:43 am

    #1224556

    ziangij (9/20/2010)

    thanks for this question... i was wondering if you could you provide a question or a query that involves both ROLLBACK WORK & ROLLBACK TRAN 🙂

    ROLLBACK WORK (or simply ROLLBACK, as the WORK keyword is optional) is completely equivalent to ROLLBACK TRAN without transaction name.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/