sys-numbered-procedure-parameters-transact-sql.md

title	sys.numbered_procedure_parameters (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	system-objects
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	numbered_procedure_parameters_TSQL sys.numbered_procedure_parameters_TSQL numbered_procedure_parameters sys.numbered_procedure_parameters
dev_langs	TSQL
helpviewer_keywords	sys.numbered_procedure_parameters catalog view
ms.assetid	a441d46d-1f30-41c2-8d94-e9442f59786e
caps.latest.revision	20
author	edmacauley
ms.author	edmaca
manager	craigg

sys.numbered_procedure_parameters (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

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