Takes actual value and expected value, checks that actual value is greater or equal than expected value and report failure if actual value is less than expected value. 

Arguments

  • V_ActualValue - actual value, DECIMAL(18,8) in SQL Server
  • V_ExpectedValue - expected value, DECIMAL(18,8) in SQL Server
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX) in SQL Server.

 

Examples

SQL Server

      EXEC DBTD_ASSERT_IS_GREATER_OR_EQUAL 100, 6, ‘Values should be greater or equal to than expected’;

 

See Also