TRY/CATCH Blocks

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  September 21, 2015 at 10:03 am

  #1828135

  I think I found the answer here:

  http://www.sqlservercentral.com/Forums/Topic1044870-392-1.aspx

  BEGIN TRY

  BEGIN TRANSACTION;

  -- Some code

  COMMIT TRANSACTION;

  END TRY

  BEGIN CATCH

  IF @@TRANCOUNT > 0

  ROLLBACK TRANSACTION;

  END CATCH;