谢谢提醒: create trigger make_tag on finanle_oderbuy for insert,update asdeclare @tag char(1)IF (select requirement from inserted) in (select finanle_budget.requirement from finanle_budget) and (select sum(amount) from finanle_oderbuy WHERE requirement = (select requirement from inserted)) < =(select amount from finanle_budget) SET @tag = '0'ELSE SET @tag = '1'update finanle_oderbuy set tag=@tag WHERE requirement = (select requirement from inserted) go
我自己也UP一下
所有一句写完,就象一个句子没有逗号一样!!
create trigger make_tag on finanle_oderbuy
for insert,update
asdeclare @tag char(1)IF (select requirement from inserted)
in (select finanle_budget.requirement from finanle_budget)
and (select sum(amount) from finanle_oderbuy WHERE requirement = (select requirement from inserted))
< =(select amount from finanle_budget)
SET @tag = '0'ELSE
SET @tag = '1'update finanle_oderbuy set tag=@tag WHERE requirement = (select requirement from inserted)
go