CREATE TRIGGER 名1 ON TABLE2
FOR INSERT
AS
insert TABLE1 (COLUMN1,COLUMN2,COLUMN3) select COLUMN11,COLUMN22,COLUMN33 from insertedCREATE TRIGGER 名2 ON TABLE2
FOR update
AS
update TABLE1 set COLUMN3=aa.COLUMN33 from inserted aa where aa.COLUMN1=TABLE1.COLUMN1 and aa.COLUMN2=table1.COLUMN2
CREATE TRIGGER 名3 ON TABLE2
FOR delete
AS
delete TABLE1 where exists(select 1 from deleted where COLUMN1=TABLE1.COLUMN1 and COLUMN2=table1.COLUMN2)
FOR INSERT
AS
insert TABLE1 (COLUMN1,COLUMN2,COLUMN3) select COLUMN11,COLUMN22,COLUMN33 from insertedCREATE TRIGGER 名2 ON TABLE2
FOR update
AS
update TABLE1 set COLUMN3=aa.COLUMN33 from inserted aa where aa.COLUMN1=TABLE1.COLUMN1 and aa.COLUMN2=table1.COLUMN2
CREATE TRIGGER 名3 ON TABLE2
FOR delete
AS
delete TABLE1 where exists(select 1 from deleted where COLUMN1=TABLE1.COLUMN1 and COLUMN2=table1.COLUMN2)
delete table2
insert table2 (COLUMN11,COLUMN22,COLUMN33,COLUMN44)
select COLUMN1,COLUMN2,COLUMN3,'' from table1
请再看叙述!!!!!!TABLE1(COLUMN1,COLUMN2,COLUMN3) 主键为COLUMN1
TABLE2(COLUMN11,COLUMN22,COLUMN33,COLUMN44) 主键为COLUMN11
两表之间可以设置外键连接
COLUMN1对应COLUMN11,COLUMN2对应COLUMN22,
而TABLE1表还有一个COLUMN3字段是独立的,
如何才能实现TABLE1,TABLE2之间的数据同步
也就是说当TABLE1表中字段COLUMN1,COLUMN2数据变化时,TABLE2表字段COLUMN11,COLUMN22也要跟着变化
本例对实时要求不是很高
谁帮我完美解决马上一百分到手了啊