• john.straver (5/23/2012)


    the answer is 0 rows when xact_abort is set to on

    the answer is 2 rows when xact_abort is set to off

    By default, SET XACT_ABORT is OFF.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins