Sqlserver 中使用事务的举例

--使用事务
begin transaction
declare @error int
set @error = 0
update bank set balance=balance-1000 where cid='0001'
set @error = @error + @@error
update bank set balance=balance + 1000 where cid='0002'
set @error = @error + @@error
if @error != 0
    rollback transaction
else
    commit transaction
go
select * from bank


举例2    --还可以使用try catch的方式
begin transaction
begin try
    update bank set balance=balance-1000 where cid='0001'
    update bank set balance=balance + 1000 where cid='0002'
    commit transaction
end try
begin catch
    rollback transaction
end catch

go
select * from bank