CREATE TRIGGER 名1 ON TABLE2
FOR INSERT
AS
insert TABLE1 (COLUMN1,COLUMN2,COLUMN3) select COLUMN11,COLUMN22,COLUMN33 from inserted
CREATE 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)