The following Microsoft SQL Server T-SQL code sample demonstrates trigger creation. Starting with SQL Servr 2005, the OUTPUT clause is available as well for similar task.

-- UPDATE, INSERT trigger - inserted / deleted special tables
-- Investment banking example - missing data fill in second table

CREATE TRIGGER trgFillInMissingCouponRate

ON [dbo].StateTaxFreeBond

FOR INSERT,UPDATE

AS

BEGIN

      UPDATE StateTaxFreeBondArchive

            SET CouponRate = isnull(i.CouponRate,m.CouponRate)

      FROM StateTaxFreeBondArchive m

            INNER JOIN inserted i

                  ON m.MBCID = i.MBCID

END

GO

-- Equivalent code

CREATE TRIGGER trgFillInMissingCouponRate

ON [dbo].StateTaxFreeBond

FOR INSERT,UPDATE

AS

BEGIN

      UPDATE m

            SET CouponRate = isnull(i.CouponRate,m.CouponRate)

      FROM StateTaxFreeBondArchive m

            INNER JOIN inserted i

                  ON m.MBCID = i.MBCID

END

GO

------------

Related articles:

CREATE TRIGGER

Exploring SQL Server Triggers

http://www.sqlusa.com/bestpractices2005/columnupdatetrigger/