事务
begin transaction
declare @sumerror int
set @sumerror=0
update bank set ballance=ballance-112 where id="xxx";
set @sumerror=@sumerror+@@error
update bank set ballance=ballance+112 where id="yyy";
set @sumerror=@sunerror+@@error;
if(@sumerror=0)
{
begin
commit transaction
end
}
else{
rollback
}
posted on 2017-12-12 19:04 CCCCCC1129 阅读(88) 评论(0) 编辑 收藏 举报
