-- CREATE TRIGGER [TESTING] ON dbo.Table1 FOR INSERT, UPDATE AS insert into Table2 (TT2Data1) SELECT testingTable1ID from inserted -- CREATE TRIGGER [TESTING2] ON dbo.Table2 FOR INSERT, UPDATE AS DECLARE @testingTable2ID int DECLARE @Data2 char(10) SET @testingTable2ID = (SELECT testingTable2ID from inserted) IF NOT UPDATE(TT2Data2) update Table2 set TT2Data2 = 'whatever' where testingTable2ID IN (SELECT testingTable2ID from inserted)