SQL: 簡單的Transaction 例子

BEGIN TRANSACTION
 ......
 update ...
 IF @@ERROR <> 0 GOTO TRAN_ABORT
 .....
COMMIT TRANSACTION
GOTO FINISH

TRAN_ABORT:
ROLLBACK TRANSACTION

FINISH:
GO