****************关于两表数据同步的触发器怎么实现？********************

[hufanxp]

有一表T1
nCurID(PK), nPntID, nName, cRemark
1 0 总部 说明
.......
表T2
nCurID（PK）, nPntID, nName, cTID cRemark)
1 0 总部 000001 说明
9 0 总部1 000009 说明1

现在想在T1上创建一个触发器，使T2与T1保持数据同步
cTID为char(6),且是nCurID的6位字符表示形式。

[lsxaa]

create trigger trig_InsertT1 on T1
for insert
as
begin
insert into T2
select nCurID,nPntID,nName,right('000000'+nCurID,6),cRemark
from inserted
end

[xuam]

CREATE trigger tr_ins on T1
for insert
as
insert into T2
select * from inserted

[btlxy]

CREATE TRIGGER ON t_1
for insert
as
insert t2 (ncurid,npntid,....)values(inserted.nCurID,nCurID.nPntID,... )

[btlxy]

CREATE TRIGGER ON t_1
on t1
for insert
as
insert t2 (ncurid,npntid,....)values(inserted.nCurID,nCurID.nPntID,... )

[xuam]

create trigger trig_Ins on T1
for insert
as

insert into T2
select nCurID,nPntID,nName,right('000000'+nCurID,6),cRemark
from inserted

[postfxj]

create trigger trig_Insert
on T1 for insert
as
insert into T2
select nCurID,nPntID,nName,right('000000'+nCurID,6),cRemark
from inserted

[hufanxp]

谢谢各位，如果在T1中有update,delete操作呢？