Assert procedure takes actual and expected MONEY or SMALLMONEY values, compares them for equality and report failure if they are not equal
Value range is from -922,337,203,685,477.5808 to 922,337,203,685,477.5807

Note: If actual or expected, or both values are NULL then assert will fail. 


  • V_ActualValue - actual value, MONEY
  • V_ExpectedValue - expected value, MONEY
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)



SQL Server

      EXEC DBTD_ASSERT_MONEY_ARE_EQUAL 5000, 5000, ‘Values should be the same’;


See Also