试试
CREATE TRIGGER [savemoney] ON dbo.tabele
FOR update
AS
begin
if update(monery)
insert into getmoneyhost(xianwei,company,monery,getter) select i.xianwei,i.company,i.monery-d.monery,i.getter from INSERTED i,DELETED d Where i.getter<>''
end
CREATE TRIGGER [savemoney] ON dbo.tabele
FOR update
AS
begin
if update(monery)
insert into getmoneyhost(xianwei,company,monery,getter) select i.xianwei,i.company,i.monery-d.monery,i.getter from INSERTED i,DELETED d Where i.getter<>''
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货