Listing 2: Code for Example 2

CREATE TABLE [dbo].[utbMyTable1] 
  ([MyIntCol] INT, [MyNCharCol] NCHAR(10))
GO
CREATE TRIGGER 
  [dbo].[TRG_utbMyTable1_Insert_Update]
ON [dbo].[utbMyTable1]
AFTER INSERT, UPDATE
AS
  INSERT INTO [dbo].[utbMyTable2] ([MyIntCol])
  SELECT [MyIntCol] FROM [inserted]
GO
CREATE TABLE [dbo].[utbMyTable2] (MyIntCol INT)
GO