ollagaza's story

SET XACT_ABORT ON
BEGIN TRY
                 BEGIN TRAN
                                 INSERT A VALUES ( '1')
                 COMMIT TRAN
                 print 'Success'
END TRY
BEGIN CATCH
                 ROLLBACK
                 print 'Fail'
END CATCH