这是我的视图: CREATE TRIGGER trg1 ON [dbo].[abcd] FOR INSERT, UPDATE, DELETE ASif exists(select 1 from inserted) if exists(select 1 from deleted) --修改 update importbg set import=b.import,unitullage=b.unitullage,ullage=b.ullage from importbg a left outer join (select * from inserted) b on a.nosc=b.nosc and a.snsp=b.snsp else --插入 insert importbg (nosc,snsp,import,unitullage,ullage) select nosc,snsp,import,unitullage,ullage from inserted else --删除 delete importbg from importbg a left outer join deleted b on a.nosc=b.nosc and a.snsp=b.snsp
CREATE TRIGGER trg1 ON [dbo].[abcd]
FOR INSERT, UPDATE, DELETE
ASif exists(select 1 from inserted)
if exists(select 1 from deleted) --修改
update importbg set import=b.import,unitullage=b.unitullage,ullage=b.ullage
from importbg a left outer join (select * from inserted) b on a.nosc=b.nosc and a.snsp=b.snsp
else
--插入
insert importbg (nosc,snsp,import,unitullage,ullage)
select nosc,snsp,import,unitullage,ullage from inserted
else --删除
delete importbg from importbg a left outer join deleted b on a.nosc=b.nosc and a.snsp=b.snsp