构造函数
constructor
new MssqlParameter( value: any, type: "decimal", precision?: number, scale?: number,): MssqlParameter 参数
- value: any
- type: "decimal"
可选precision: number可选scale: number
new MssqlParameter( value: any, type: "numeric", precision?: number, scale?: number,): MssqlParameter 参数
- value: any
- type: "numeric"
可选precision: number可选scale: number
参数
- value: any
- type: "smallint"
参数
- value: any
- type: "smallmoney"
参数
- value: any
- type: "tinyint"
new MssqlParameter(value: any, type: "char", length?: number): MssqlParameter 参数
- value: any
- type: "char"
可选length: number
new MssqlParameter(value: any, type: "nchar", length?: number): MssqlParameter 参数
- value: any
- type: "nchar"
可选length: number
new MssqlParameter(value: any, type: "varchar", length?: number): MssqlParameter 参数
- value: any
- type: "varchar"
可选length: number
new MssqlParameter( value: any, type: "nvarchar", length?: number,): MssqlParameter 参数
- value: any
- type: "nvarchar"
可选length: number
new MssqlParameter(value: any, type: "time", scale?: number): MssqlParameter 参数
- value: any
- type: "time"
可选scale: number
参数
- value: any
- type: "datetime"
new MssqlParameter( value: any, type: "datetime2", scale?: number,): MssqlParameter 参数
- value: any
- type: "datetime2"
可选scale: number
new MssqlParameter( value: any, type: "datetimeoffset", scale?: number,): MssqlParameter 参数
- value: any
- type: "datetimeoffset"
可选scale: number
参数
- value: any
- type: "smalldatetime"
new MssqlParameter(value: any, type: "uniqueidentifier"): MssqlParameter 参数
- value: any
- type: "uniqueidentifier"
参数
- value: any
- type: "variant"
new MssqlParameter( value: any, type: "varbinary", length?: number,): MssqlParameter 参数
- value: any
- type: "varbinary"
可选length: number
参数
- value: any
- type: "geography"
参数
- value: any
- type: "geometry"
参数
- value: any
- type: "rowversion"
属性
只读@instanceof
"@instanceof": symbol
params
params: any[]
type
type: string
value
value: 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