Table of Contents

Class ObjectSchema.NumberedProcedureParameter

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.numbered_procedure_parameters (Transact-SQL)

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.


See sys.numbered_procedure_parameters.

[Table(Schema = "sys", Name = "numbered_procedure_parameters", IsView = true)]
public class ObjectSchema.NumberedProcedureParameter
Inheritance
ObjectSchema.NumberedProcedureParameter
Inherited Members
Extension Methods

Properties

IsCursorRef

is_cursor_ref NOT NULL bit

1 = Parameter is a cursor-reference parameter. 
[Column("is_cursor_ref")]
[NotNull]
public bool IsCursorRef { get; set; }

Property Value

bool

IsOutput

is_output NOT NULL bit

1 = Parameter is output or return; otherwise, 0 
[Column("is_output")]
[NotNull]
public bool IsOutput { get; set; }

Property Value

bool

MaxLength

max_length NOT NULL smallint

Maximum length of the parameter in bytes.

-1 = Column data type is varchar(max), nvarchar(max), or varbinary(max). 
[Column("max_length")]
[NotNull]
public short MaxLength { get; set; }

Property Value

short

Name

name NULL sysname

Name of the parameter. Is unique within procedure_number. 
[Column("name")]
[Nullable]
public string? Name { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL int

ID of the object to which this parameter belongs. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ParameterID

parameter_id NOT NULL int

ID of the parameter. Is unique within the procedure_number. 
[Column("parameter_id")]
[NotNull]
public int ParameterID { get; set; }

Property Value

int

Precision

precision NOT NULL tinyint

Precision of the parameter if numeric-based; otherwise, 0. 
[Column("precision")]
[NotNull]
public byte Precision { get; set; }

Property Value

byte

ProcedureNumber

procedure_number NOT NULL smallint

Number of this procedure within the object, 2 or greater. 
[Column("procedure_number")]
[NotNull]
public short ProcedureNumber { get; set; }

Property Value

short

Scale

scale NOT NULL tinyint

Scale of the parameter if numeric-based; otherwise, 0. 
[Column("scale")]
[NotNull]
public byte Scale { get; set; }

Property Value

byte

SystemTypeID

system_type_id NOT NULL tinyint

ID of the system type of the parameter 
[Column("system_type_id")]
[NotNull]
public byte SystemTypeID { get; set; }

Property Value

byte

UserTypeID

user_type_id NOT NULL int

ID of the type, as defined by user, of the parameter. 
[Column("user_type_id")]
[NotNull]
public int UserTypeID { get; set; }

Property Value

int