Assert procedure that takes actual and expected HIERARCHYID values, compares them for equality and report failure if they are not equal
Note: If actual or expected, or both values are NULL then assert will fail.
Arguments
-
V_ActualValue - actual value, HIERARCHYID
-
V_ExpectedValue - expected value, HIERARCHYID
-
v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)
Examples
SQL Server
EXEC DBTD_ASSERT_HIERARCHYID_ARE_EQUAL '/1/2/3', '/1/2/3/4', ‘Values should be the same’;
See Also