--用触发器。
CREATE TRIGGER tr_同步追加 ON 表1
FOR INSERT
AS
insert into 表2(x1,y1,data1,time1)
select x1,y1,data1,time1
from inserted
go
CREATE TRIGGER tr_同步追加 ON 表1
FOR INSERT
AS
insert into 表2(x1,y1,data1,time1)
select x1,y1,data1,time1
from inserted
go
-->右键
-->所有任务
-->管理触发器
-->添加如上代码