SQL Server 事务
标签：影响 upd har catch 使用 常用 weight var color
SQL Server 事务
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