john.straver (5/23/2012)
the answer is 0 rows when xact_abort is set to onthe 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