--建表
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
转账和事务的例子
最新推荐文章于 2024-01-06 17:06:47 发布