分别插入表a,b的触发器怎么写，谢谢，救命呀

[amoo]

表a
id
name

表b
id
name

现在在表a插入一条数据，把这条数据在插入表b中，谁能给你例子，谢谢了

[pliao608]

create triggle tri_1 on a
for insert
as
insert b select id,name from inserted

[sdhdy]

create trigger trig_a_insert on a
for insert
as
insert b select * from inserted

[haozhiyuan2003]

create trigger tr_a_insert on a
for insert
as
insert into b select * from inserted

[hjb111]

create trigger T_insert_a on 表A for insert
as
insert b select * from inserted
go

[pengdali]

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 表a

for insert

as

insert into 表b(id,name)
SELECT ins.id,
ins.name,
FROM inserted ins

[happydreamer]

参考以下 2个表之间数据关联插入 更新 删除的触发器

CREATE TRIGGER 名1 ON dbo.tabMain
FOR INSERT
AS
insert db2..tabSlave select * from inserted

CREATE 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)

[CrazyFor]

create trigger 触发器名 on a
for insert
as
insert b select * from inserted