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