1: DECLARE @CurrentError int
2: BEGIN TRANSACTION
3: -- 开始更新数据的事务
4: /*
5: **这里执行业务操作**
6: */
7: -- 错误检查
8: SELECT @CurrentError = @@Error
9: IF @CurrentError != 0
10: BEGIN
11: GOTO ERROR_HANDLER
12: END
13: /*
14: **这里执行业务操作**
15: */
16: -- 错误检查
17: SELECT @CurrentError = @@Error
18: IF @CurrentError != 0
19: BEGIN
20: GOTO ERROR_HANDLER
21: END
22: -- 事务结束
23: COMMIT TRANSACTION
24: RETURN 0
25:
26: ERROR_HANDLER:
27: ROLLBACK TRANSACTION
28: RETURN @CurrentError
网上搜集 暂未测试