create trigger tr_a_insert on a for insert as insert into b select * from inserted
create trigger T_insert_a on 表A for insert as insert b select * from inserted go
CREATE TRIGGER 名1 ON 表a FOR INSERT AS insert 表b (id,name) select id,name from inserted go
create trigger t1 on 表a for insert as insert 表b select * from inserted
CREATE TRIGGER insert_b on 表afor insertas insert into 表b(id,name) SELECT ins.id, ins.name, FROM inserted ins
参考以下 2个表之间数据关联插入 更新 删除的触发器CREATE TRIGGER 名1 ON dbo.tabMain FOR INSERT AS insert db2..tabSlave select * from insertedCREATE TRIGGER 名2 ON dbo.tabMain FOR update AS update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号 CREATE TRIGGER 名3 ON dbo.tabMain FOR delete AS delete db2..tabSlave where 编号 in (select 编号 from deleted)
create trigger 触发器名 on a for insert as insert b select * from inserted
create triggle tri_1 on a for insert as insert b select id,name from inserted
for insert
as
insert into b select * from inserted
as
insert b select * from inserted
go
FOR INSERT
AS
insert 表b (id,name) select id,name from inserted
go
as
insert 表b select * from inserted
on 表afor insertas insert into 表b(id,name)
SELECT ins.id,
ins.name,
FROM inserted ins
FOR INSERT
AS
insert db2..tabSlave select * from insertedCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
CREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
for insert
as
insert b select * from inserted
for insert
as
insert b select id,name from inserted