谢谢!create trigger chb_tirg_1 on wk_contractafter insertasbeginupdate wk set wk.famount=i.fcontractcost from wk_contract wk,inserted i where wk.fcontractNumber=i.fcontractNumberend
create trigger chb_tirg_1 on wk_contractafter insertasbeginupdate wk set wk.famount=i.fcontractcost from wk_contract wk,inserted i where wk.fcontractNumber=i.fcontractNumberend
Create trigger Tb_Ins on tbinstead of insert as begin Set nocount on; declare @A int, @B int set @A = (Select a from inserted) set @B = (Select b from inserted) insert into tb(a, b) values (@B, @A)end
