N简单的问题 触发器相关

[zwx963536]

table1 {cardno,name,pwd}
table2 {cardno,name}
当向table1插入一条新记录时，把这条记录新写入table2中

用触发器怎么写出来？谢了大哥大姐们！

[sdhdy]

create trigger tri_table1_insert on table1
for insert
as
insert table2 select cardno,name from inserted

[pengdali]

CREATE TRIGGER 名1 ON table1
FOR INSERT
AS
insert table2 (cardno,name) select cardno,name from inserted

[pengdali]

下面3个触发器演示了如何同步两个不同库的两个表

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

CREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
go

CREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)

[lynx1111]

CREATE TRIGGER 名1 ON table1
FOR INSERT
AS
insert table2 (cardno,name) select cardno,name from inserted


deleted 和 inserted 是逻辑（概念）表。这些表在结构上类似于定义触发器的表（也就是在其中尝试用户操作的表）；这些表用于保存用户操作可能更改的行的旧值或新值。例如，若要检索 deleted 表中的所有值，请使用：
SELECT *
FROM deleted

[zwx963536]

那Update呢？ 不会是updated吧？（*^o^*)

[txlicenhe]

CREATE TRIGGER 名1 ON table1
FOR INSERT
AS
insert table2 (cardno,name) select cardno,name from inserted


For Insert触发器只有inserted表
For Delete触发器只有deleted表
For Update触发器有inserted & deleted表