sys.numbered_procedure_parameters (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

sys.numbered_procedure_parameters (Transact-SQL)

 

Updated: June 10, 2016

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).

System_CAPS_ICON_important.jpg 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.

System_CAPS_ICON_note.jpg Note


XML and CLR parameters are not supported for numbered procedures.

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
object_idintID of the object to which this parameter belongs.
procedure_numbersmallintNumber of this procedure within the object, 2 or greater.
namesysnameName of the parameter. Is unique within procedure_number.
parameter_idintID of the parameter. Is unique within the procedure_number.
system_type_idtinyintID of the system type of the parameter
user_type_idintID of the type, as defined by user, of the parameter.
max_lengthsmallintMaximum length of the parameter in bytes.

-1 = Column data type is varchar(max), nvarchar(max), or varbinary(max).
precisiontinyintPrecision of the parameter if numeric-based; otherwise, 0.
scaletinyintScale of the parameter if numeric-based; otherwise, 0.
is_outputbit1 = Parameter is output or return; otherwise, 0
is_cursor_refbit1 = Parameter is a cursor-reference parameter.
System_CAPS_ICON_note.jpg 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 has been granted some permission. For more information, see Metadata Visibility Configuration.

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft