事务应用实例

bank表:

 

事务:

begin transaction     --开启事务
declare @err int
set @err=0
update bank set currentMoney=currentMoney+1000
  where customerName='张三'
set @err=@err+@@error
update bank set currentMoney=currentMoney-1000
  where customerName='陈晨'
set @err=@err+@@error
if(@err>0)   --确定是否有误,确定事务是提交还是撤销
begin
  rollback transaction   --回滚事务
end
  else
begin
  commit transaction     --提交事务
end

select * from bank

执行结果如下图: