sys.numbered_procedures (Transact-SQL)sys.numbered_procedures (Transact-SQL)

适用对象: yesSQL ServernoAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

每个作为带编号的过程而创建的 SQL Server 存储过程都占一行。Contains a row for each SQL Server stored procedure that was created as a numbered procedure. 对于基(编号 = 1)存储过程,它不显示行。This does not show a row for the base (number = 1) stored procedure. 在视图中可以如找到基存储过程的条目sys.objectssys.proceduresEntries for the base stored procedures can be found in views such as sys.objects and sys.procedures.


不推荐使用带编号的过程。Numbered procedures are deprecated. 建议您不要使用带编号过程。Use of numbered procedures is discouraged. 当编译使用此目录视图的查询时,将会激发 DEPRECATION_ANNOUNCEMENT 事件。A DEPRECATION_ANNOUNCEMENT event is fired when a query that uses this catalog view is compiled.

列名Column name 数据类型Data type 描述Description
object_idobject_id intint 存储过程的对象的 ID。ID of the object of the stored procedure.
procedure_numberprocedure_number smallintsmallint 对象中这种过程的数目(2 或更多)。Number of this procedure within the object, 2 or greater.
定义definition nvarchar(max)nvarchar(max) 用于定义此过程的 SQL Server 文本。The SQL Server text that defines this procedure.

NULL = 已加密。NULL = encrypted.


带编号的过程不支持 XML 和 CLR 参数。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. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

请参阅See Also

对象目录视图 (Transact-SQL) Object Catalog Views (Transact-SQL)
目录视图 (Transact-SQL)Catalog Views (Transact-SQL)