请教一个简单的触发器问题

[huhu_yxf]

a表中id，name两个字段
b表中有name字段
对a表进行insert操作
想建立触发器
同时对a表的name字段也进行insert操作，且a.name=b.nameanme
请问怎么写

[huhu_yxf]

前面写错了
应该触发b进行insert
使得b.name=a.name
谢谢

[老乐]

create trigger instaba
for insert
as
insert into tabb (name)
select name from inserted

[Cham]

对A表操作，触发器应该建立在Ａ表上
Create Trigger Tr_InsA on dbo.A
For Insert
As
declare @name as char(?)
select @name = name from inserted
Insert into b (name) values (@name)

[Cham]

你对那个表操作，触发器就应该建立在那个表上

Create trigger T_InsA On dbo.a
for Insert
As
Insert into b
select name from Inserted

[lgh21cn]

Create trigger tr_insert_a On dbo.a
for Insert
As
Insert into b select i.name from Inserted i

[lgh21cn]

Create trigger tr_insert_a On dbo.a
for Insert
As
Insert into b select i.name from Inserted i