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