Checks that actual value IS NULL and report failure if actual value IS NOT NULL.
Arguments
-
V_ActualValue - actual value, NVARCHAR(4000).
-
v_UserMessage – message to report when assertion fails, NVARCHAR(MAX).
Examples
SQL Server
CREATE PROCEDURE UT_DBTD_CheckThatDeleteDateIsNULL
AS
BEGIN
DECLARE @v_DeleteDate DATETIME;
DECLARE @v_Customer INT = 123456789;
SET @v_DeleteDate = dbo.fnGetCustomerDeleteDate(@v_Customer);
EXEC DBTD_ASSERT_IS_NULL @v_DeleteDate, 'Existing customer should not have any delete date';
END;
GO
See Also