Listing 7. Statement That Adds Test Result Data to tabConfigSettings Table

IF @ProductVersion >= '8.00.2039'
  BEGIN
   UPDATE tabConfigSettings
   SET ActualSetting = @ProductVersion,
     TestResult = 'PASS',
     Tester = CURRENT_USER,
     TestDate = getdate()
   WHERE ConfigItem = 'Version#'
   END
  ELSE
   BEGIN
   UPDATE tabConfigSettings
   SET ActualSetting = @ProductVersion,
       TestResult = 'FAIL',
       Tester = CURRENT_USER,
       TestDate = getdate()
   WHERE ConfigItem = 'Version#'
   END