如何将表1中新添加的数据插入到表2 中?

ccwlm741212

应该有变动也需要更新，否则数据的完整性就没保障了

lynx286

用触发器简单同步两个表:

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

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

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

jamesleeli

to ynx286

update tabSlave set 列=aa.列 from inserted aa where aa.编号=tabSlave.编号
有这种语法？？

jamesleeli

to ynx286
高手就是高手呀。我服了。又多学了一招了。谢谢！！！！