-----M_RyKh为一个假定的视图名
CREATE TRIGGER [TRIGGER NAME] ON [dbo].[M_RyKh]
FOR INSERT, UPDATE, DELETE
AS
---删除数据
if not exists( select 1 from inserted )
begin
delete AAA from AAA
inner join deleted a on ---条件
return;
end
---添加数据
if not exists (select 1 from deleted )
begin
-------添加语句
return ;
end
---下面为更新语句