从 0002 转账 900元给 0001
create table bank
(
cId char(4) primary key,
blance money,
)
alter table bank
add constraint CH_blance check(blance>=10)
insert into bank values('0001',10)
insert into bank values('0002',1000)
select * from bank
下面是事务：
begin transaction
declare @error int; --declare @error int 声明一个整型变量@error
update bank set blance=blance+900 where cId='0001'
set @error=(select @@ERROR) --@@ERROR:前面一条语句执行成功返回0，否则返回错误码
update bank set blance=blance-900 where cId='0002'
set @error+=(select @@ERROR)
if(@error=0)
begin
commit
end
else
begin
rollback
end
