Web Listing 4. Code That Creates a Trigger to Log a Bug Report

CREATE TRIGGER trgLogBug
ON tabConfigSettings
FOR update
AS
IF (select testresult from deleted) = 'FAIL'
   BEGIN
   DECLARE @TestID INT, @ConfigItem varchar(32),
      @ExpectedSetting varchar(64),
      @ActualSetting varchar(64), @Tester varchar(32)
   SELECT @TestID = SettingID,
      @ConfigItem = ConfigItem,
      @ExpectedSetting = ExpectedSetting,
      @ActualSetting = ActualSetting,
      @Tester =Tester
   FROM inserted
   INSERT tabBugReports (TestID, ConfigItem, DateLogged,
      ExpectedSetting, ActualSetting,Tester, Status)
   VALUES (@TestID,@ConfigItem, getdate(),@ExpectedSetting,
      @ActualSetting, @Tester, 'Debugging')
END
RETURN