Web Listing 2. Stored Procedure That Automatically Logs Test Results

CREATE PROC upUpdateTestCase
      @@TestResult varchar(10),
      @@ActualSetting varchar(64),
      @@ConfigItem varchar(64)
AS
SET NOCOUNT ON
   IF @@TestResult = 'FAILED'
   BEGIN
      UPDATE tabConfigSettings 
      SET ActualSetting = @@ActualSetting,
      TestResult = 'FAIL',
      Tester = CURRENT_USER,
      TestDate =  getdate()
   WHERE ConfigItem = @@ConfigItem
   END
   ELSE
   BEGIN
      UPDATE tabConfigSettings
      SET ActualSetting = @@ActualSetting,
      TestResult = 'PASS',
      Tester = CURRENT_USER,
      TestDate =  getdate()
   WHERE ConfigItem = @@ConfigItem
   END
RETURN