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.

权限Permissions

目录视图中仅显示用户拥有的安全对象的元数据,或用户对其拥有某些权限的安全对象的元数据。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)