Assert procedure that takes actual and expected FLOAT values, compares them for equality and report failure if they are not equal.
Value range is from -1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308
Note: If actual or expected, or both values are NULL then assert will fail.
Arguments
-
V_ActualValue - actual value, FRLOAT(53)
-
V_ExpectedValue - expected value, FLOAT(53)
-
v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)
Examples
SQL Server
EXEC DBTD_ASSERT_FLOAT_ARE_EQUAL 50121, 325436534, ‘Values should be the same’;
See Also