BEGIN TRAN Tran_Money –开始事务
DECLARE @tran_error int;
SET @tran_error = 0;
BEGIN TRY
UPDATE tb_Money SET MyMoney = MyMoney - 30 WHERE Name = ‘刘备’;
SET @tran_error = @tran_error + @@ERROR;
–测试出错代码，看看刘备的钱减少，关羽的钱是否会增加
–SET @tran_error = 1;
UPDATE tb_Money SET MyMoney = MyMoney + 30 WHERE Name = ‘关羽’;
SET @tran_error = @tran_error + @@ERROR;
END TRY
BEGIN CATCH
PRINT ‘出现异常，错误编号：’ + convert(varchar,error_number()) + ‘,错误消息：’ + error_message()
SET @tran_error = @tran_error + 1
END CATCH
IF(@tran_error > 0)
BEGIN
–执行出错，回滚事务
ROLLBACK TRAN;
PRINT ‘转账失败，取消交易!’;
END
ELSE
BEGIN
–没有异常，提交事务
COMMIT TRAN;
PRINT ‘转账成功!’;
END
