CREATE trigger TR1 ON 存取款单
for insert
as

if (select 存取标志 from inserted )=1
begin
update 储户
set 存款额=存款额+存取金额
from 储户 as a,inserted as b
where a.帐号=b.帐号
end
if (select 存取标志 from inserted)=0
begin
update 储户
set 存款额=存款额-存取金额
from 储户 as a,inserted as b
where a.帐号=b.帐号
end
if (select 储户.存款额 from 储户,inserted where inserted.帐号=储户.帐号)<(select inserted.存取金额 from inserted)
begin
print '该用户金额不足，不能再取款'
rollback transaction
end
其中

print '该用户金额不足，不能再取款' 这句是不是有问题？为什么当取款比存款额多是，不会报错

if (select 储户.存款额 from 储户,inserted where inserted.帐号=储户.帐号)<(select inserted.存取金额 from inserted)
应该是这里的问题

回复不了的?

if (select 储户.存款额 from 储户,inserted where inserted.帐号=储户.帐号)<(select inserted.存取金额 from inserted)
后者少where条件吧?如果查出来不只一条记录就没法比较了.

create trigger TR1 on 存取款单 for insert
as if
(select inserted.存取金额 from 存取款单,inserted where
存取款单.账号=inserted.账号 and 存取款单.存取标志=1)
is not null

update 储户 set 存款额=存款额+(select inserted.存取金额 from inserted,存取款单
where 存取款单.帐号=inserted.账号) where
储户.账号=inserted.账号 and
储户.账号=(select 账号 from inserted)

if (select inserted.存取金额 from 存取款单,inserted where
存取款单.账号=inserted.账号 and 存取款单.存取标志=0)
is not null

update 储户 set 存款额=存款额-(select inserted.存取金额 from inserted,存取款单
where 存取款单.账号=inserted.账号)
where 储户.账号=inserted.账号 and
储户.账号=(select 账号 from inserted)

if (select inserted.存取金额 from 存取款单,inserted where
存取款单.账号=inserted.账号 and 存取款单.存取标志=0 )<存取款单.存取金额
begin print
'余额不足!'
end

这个这样写可能可以吧!~!