DB Test Driven

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

• DBTD_ASSERT_COLUMN_NOT_EXISTS

• DDL Assertions