Home Forums Testing Center Question of the Day (QOD) Question of the Day for 20 Jun 2007 RE: Question of the Day for 20 Jun 2007

  • June 20, 2007 at 12:54 am

    #714011

    Hi,

    The explanation of this question says:

    "This statement works like the ROLLBACK TRANSACTION statement, but it rolls back to the outer transaction and resets @@trancount to 0"

    Whereas it should say:

    "This statement works like the ROLLBACK TRANSACTION statement, and as such it rolls back to the outer transaction and resets @@trancount to 0"

    ROLLBACK WORK is exactly the same as ROLLBACK TRAN

    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/