create proc test
@sum int
as
begin
begin transaction
set @sum=0
update ecsuser set vmoney=vmoney-100 where userid=19
set @sum=@sum+@@error
update ecsuser set vmoney=vmoney+100 where userid=20
set @sum=@sum+@@error
if @sum<>0
begin
print '修改失败,事物回滚'
rollback transaction--事物回滚
end
else
begin
print '修改成功,事物提交'
commit transaction--事物提交
end
return @sum
end
SQLserver用事物跟新数据
最新推荐文章于 2024-08-28 04:00:00 发布