create trigger tri_insert on 表1 for insert as begin insert db1.dbo.表2(f1,f2,f3) select 表1.f1,表1.f2,表1.f3 from inserted 表1 end
create trigger trg_t1 on t1 for insert as insert into t2(...) select ... from inserted go
create trigger trg_common on table1 for insert as insert into table2(col1,col2,...,col3) select * from inserted
CREATE TRIGGER tr1 ON t1 FOR INSERT, UPDATE, DELETE AS delete t2 where exists(select 1 from deleted d where d.id = t2.id) insert t2 select ...... from inserted
--插入 create trigger trg_t1 on t1 for insert as insert into t2(...) select ... from inserted go --更新 create trigger trg_t1 on t1 for update as update t2 set col1=i.col1,col2=i.col2...--这是修改字段的值 from inserted i ,deleted d where d.col1=t2.col1,d.col2=i.col2--这是相互关联的条件 --删除 create trigger trg_t1 on t1 after delete as delete t2 from delete d where d.col1=t2.col1,d.col2=i.col2--
for insert
as
begin
insert db1.dbo.表2(f1,f2,f3)
select 表1.f1,表1.f2,表1.f3 from inserted 表1
end
for insert
as
insert into t2(...) select ... from inserted
go
create trigger trg_common on table1
for insert
as
insert into table2(col1,col2,...,col3)
select * from inserted
FOR INSERT, UPDATE, DELETE
AS
delete t2 where exists(select 1 from deleted d where d.id = t2.id)
insert t2 select ...... from inserted
create trigger trg_t1 on t1
for insert
as
insert into t2(...) select ... from inserted
go
--更新
create trigger trg_t1 on t1
for update
as
update t2
set col1=i.col1,col2=i.col2...--这是修改字段的值
from inserted i ,deleted d
where d.col1=t2.col1,d.col2=i.col2--这是相互关联的条件
--删除
create trigger trg_t1 on t1
after delete
as
delete t2
from delete d
where d.col1=t2.col1,d.col2=i.col2--