Constructors
constructor
- new MssqlParameter(value: any, type: "bit"): MssqlParameter
- new MssqlParameter(value: any, type: "bigint"): MssqlParameter
- new MssqlParameter(value: any, type: "decimal", precision?: undefined | number, scale?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "float"): MssqlParameter
- new MssqlParameter(value: any, type: "int"): MssqlParameter
- new MssqlParameter(value: any, type: "money"): MssqlParameter
- new MssqlParameter(value: any, type: "numeric", precision?: undefined | number, scale?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "smallint"): MssqlParameter
- new MssqlParameter(value: any, type: "smallmoney"): MssqlParameter
- new MssqlParameter(value: any, type: "real"): MssqlParameter
- new MssqlParameter(value: any, type: "tinyint"): MssqlParameter
- new MssqlParameter(value: any, type: "char", length?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "nchar", length?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "text"): MssqlParameter
- new MssqlParameter(value: any, type: "ntext"): MssqlParameter
- new MssqlParameter(value: any, type: "varchar", length?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "nvarchar", length?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "xml"): MssqlParameter
- new MssqlParameter(value: any, type: "time", scale?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "date"): MssqlParameter
- new MssqlParameter(value: any, type: "datetime"): MssqlParameter
- new MssqlParameter(value: any, type: "datetime2", scale?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "datetimeoffset", scale?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "smalldatetime"): MssqlParameter
- new MssqlParameter(value: any, type: "uniqueidentifier"): MssqlParameter
- new MssqlParameter(value: any, type: "variant"): MssqlParameter
- new MssqlParameter(value: any, type: "binary"): MssqlParameter
- new MssqlParameter(value: any, type: "varbinary", length?: undefined | number): MssqlParameter
- new MssqlParameter(value: any, type: "image"): MssqlParameter
- new MssqlParameter(value: any, type: "udt"): MssqlParameter
- new MssqlParameter(value: any, type: "geography"): MssqlParameter
- new MssqlParameter(value: any, type: "geometry"): MssqlParameter
- new MssqlParameter(value: any, type: "rowversion"): MssqlParameter
-
Parameters
-
Parameters
-
value: any
-
type: "bigint"
-
Parameters
-
value: any
-
type: "decimal"
-
Optional precision: undefined | number
-
Optional scale: undefined | number
-
Parameters
-
Parameters
-
Parameters
-
Parameters
-
value: any
-
type: "numeric"
-
Optional precision: undefined | number
-
Optional scale: undefined | number
-
Parameters
-
value: any
-
type: "smallint"
-
Parameters
-
value: any
-
type: "smallmoney"
-
Parameters
-
Parameters
-
value: any
-
type: "tinyint"
-
Parameters
-
value: any
-
type: "char"
-
Optional length: undefined | number
-
Parameters
-
value: any
-
type: "nchar"
-
Optional length: undefined | number
-
Parameters
-
Parameters
-
Parameters
-
value: any
-
type: "varchar"
-
Optional length: undefined | number
-
Parameters
-
value: any
-
type: "nvarchar"
-
Optional length: undefined | number
-
Parameters
-
Parameters
-
value: any
-
type: "time"
-
Optional scale: undefined | number
-
Parameters
-
Parameters
-
value: any
-
type: "datetime"
-
Parameters
-
value: any
-
type: "datetime2"
-
Optional scale: undefined | number
-
Parameters
-
value: any
-
type: "datetimeoffset"
-
Optional scale: undefined | number
-
Parameters
-
value: any
-
type: "smalldatetime"
-
Parameters
-
value: any
-
type: "uniqueidentifier"
-
Parameters
-
value: any
-
type: "variant"
-
Parameters
-
value: any
-
type: "binary"
-
Parameters
-
value: any
-
type: "varbinary"
-
Optional length: undefined | number
-
Parameters
-
Parameters
-
Parameters
-
value: any
-
type: "geography"
-
Parameters
-
value: any
-
type: "geometry"
-
Parameters
-
value: any
-
type: "rowversion"
Properties
params
params: any[] = []
Sql server driver requires parameter types to be specified fo input parameters used in the query.
https://github.com/patriksimek/node-mssql#data-types