TediousUtils.Function.deriveParamDataTypeFromValue

tedious-plus / TediousUtils / deriveParamDataTypeFromValue

Function: deriveParamDataTypeFromValue()

function deriveParamDataTypeFromValue(value): DataType;

Defined in: TediousUtils.ts:454

Derives the SQL parameter data type from a JavaScript value.

Value	Data type
string	NVarChar
number, int32 range	Int
number, other safe integer	BigInt
number, other	Float
bigint	BigInt
boolean	Bit
Buffer	VarBinary
Date	DateTime2
null, undefined	Bit (passed as NULL)

Parameters

value

unknown

The parameter value.

Returns

DataType

The Tedious data type.

Throws

Error If the data type of the value is not supported.