LISTING 3: Code to Create Tables and a Trigger That Inserts Records
CREATE TABLE dbo.tab1 (celsius int)
CREATE TABLE dbo.tab2 (fahrenheit int ) -- to show that data can be transformed in the trigger
GO
CREATE TRIGGER myInsertTrigger 
   ON dbo.tab1
   FOR INSERT AS
-- inserted is a special table containing the inserted records.
      INSERT INTO dbo.tab2 SELECT (col1*9)/5+32 FROM inserted

GO
INSERT dbo.tab1(celsius) VALUES(37)
GO
-- Confirm that the insert into tab1 has propagated to tab2.
SELECT * FROM dbo.tab2 
GO