转账的事务例子

 

                                                                                      

--建表
create table bank
(
cid int identity(1,1) primary key not null,
name nvarchar(32) not null,
qian int not null
)

--添加数据
insert into bank (name,qian) values('郭华',10000000)
insert into bank (name,qian) values('敖晴',100)

--添加约束
alter table bank
add constraint  CK_qian check (qian>=1)

--转账

declare @cuowu int
SET @cuowu=0

begin transaction --开启事务

update bank set qian-=100 where cid=3
set @cuowu+=@@ERROR
update bank set qian+=100 where cid =4
set @cuowu+=@@ERROR
if(@cuowu>0)
begin
rollback transaction --回滚
end
else
begin
commit transaction  --提交
end

select * from bank