Checks that parameter exist for an object that accepts parameters. Assert will fail when parameter with a given name could not be found.

Arguments

  • v_ObjectName – name of the object that accepts parameters. Supports four part object name, SYSNAME in SQL Server
  • v_ParameterName – name of the parameter, SYSNAME in SQL Server
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX) in SQL Server

 

Examples

SQL Server 

      EXEC DBTD_ASSERT_PARAMETER_EXISTS 'procOrderDetails', '@OrderNumber', 'Cannot find parameter';

See Also