TediousUtils.Interface.SqlParamDef

tedious-plus / TediousUtils / SqlParamDef

Interface: SqlParamDef

Defined in: TediousUtils.ts:311

A complete SQL parameter definition, with name, value and data type.

Extends

• SqlParamValueAndDataType

Properties

length?

length?: number;

Defined in: TediousUtils.ts:286

The length, for string and binary data types (e.g. NVarChar, VarBinary).

Inherited from

SqlParamValueAndDataType.length

---

name

name: string;

Defined in: TediousUtils.ts:316

The parameter name, without the @ prefix.

---

precision?

precision?: number;

Defined in: TediousUtils.ts:291

The precision, for the data types Decimal and Numeric.

Inherited from

SqlParamValueAndDataType.precision

---

scale?

scale?: number;

Defined in: TediousUtils.ts:296

The scale, for the data types Decimal, Numeric, Time, DateTime2 and DateTimeOffset.

Inherited from

SqlParamValueAndDataType.scale

---

type

type: DataType;

Defined in: TediousUtils.ts:281

The Tedious data type, e.g. Tedious.TYPES.Int.

Inherited from

SqlParamValueAndDataType.type

---

value

value: unknown;

Defined in: TediousUtils.ts:306

The parameter value. null or undefined is passed as SQL NULL.

Inherited from

SqlParamValueAndDataType.value