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 (all supported versions)

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
Extension Methods

Properties

IsCursorRef

1 = Parameter is a cursor-reference parameter.

[Column("is_cursor_ref")]
[NotNull]
public bool IsCursorRef { get; set; }

Property Value

bool

IsOutput

1 = Parameter is output or return; otherwise, 0

[Column("is_output")]
[NotNull]
public bool IsOutput { get; set; }

Property Value

bool

MaxLength

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

ID of the object to which this parameter belongs.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ParameterID

ID of the parameter. Is unique within the procedure_number.

[Column("parameter_id")]
[NotNull]
public int ParameterID { get; set; }

Property Value

int

Precision

Precision of the parameter if numeric-based; otherwise, 0.

[Column("precision")]
[NotNull]
public byte Precision { get; set; }

Property Value

byte

ProcedureNumber

Number of this procedure within the object, 2 or greater.

[Column("procedure_number")]
[NotNull]
public short ProcedureNumber { get; set; }

Property Value

short

Scale

Scale of the parameter if numeric-based; otherwise, 0.

[Column("scale")]
[NotNull]
public byte Scale { get; set; }

Property Value

byte

SystemTypeID

ID of the system type of the parameter

[Column("system_type_id")]
[NotNull]
public byte SystemTypeID { get; set; }

Property Value

byte

UserTypeID

ID of the type, as defined by user, of the parameter.

[Column("user_type_id")]
[NotNull]
public int UserTypeID { get; set; }

Property Value

int