Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Contains one row for each parameter of a numbered procedure. When you create a numbered stored procedure, the base procedure is number 1. All subsequent procedures have numbers 2, 3, and so forth. sys.numbered_procedure_parameters contains the parameter definitions for all subsequent procedures, numbered 2 and greater. This view does not show parameters for the base stored procedure (number = 1). The base stored procedure is similar to a nonnumbered stored procedure. Therefore, its parameters are represented in sys.parameters (Transact-SQL).
Important
Numbered procedures are deprecated. Use of numbered procedures is discouraged. A DEPRECATION_ANNOUNCEMENT event is fired when a query that uses this catalog view is compiled.
Note
XML and CLR parameters are not supported for numbered procedures.
| Column name | Data type | Description |
|---|---|---|
| object_id | int | ID of the object to which this parameter belongs. |
| procedure_number | smallint | Number of this procedure within the object, 2 or greater. |
| name | sysname | Name of the parameter. Is unique within procedure_number. |
| parameter_id | int | ID of the parameter. Is unique within the procedure_number. |
| system_type_id | tinyint | ID of the system type of the parameter |
| user_type_id | int | ID of the type, as defined by user, of the parameter. |
| max_length | smallint | Maximum length of the parameter in bytes. -1 = Column data type is varchar(max), nvarchar(max), or varbinary(max). |
| precision | tinyint | Precision of the parameter if numeric-based; otherwise, 0. |
| scale | tinyint | Scale of the parameter if numeric-based; otherwise, 0. |
| is_output | bit | 1 = Parameter is output or return; otherwise, 0 |
| is_cursor_ref | bit | 1 = Parameter is a cursor-reference parameter. |
Note
XML and CLR parameters are not supported for numbered procedures.
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)