|
The following
Microsoft SQL Server T-SQL code sample with an investment banking example demonstrates triggers
for missing data fillin in a second table. Starting with SQL Servr 2005, the OUTPUT clause is available as well for similar task.
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
|