Showing content from http://tediousjs.github.io/tedious/api-datatypes.html below:
API - Datatypes | Tedious
Supported datatypes Type Constant JavaScript Result set Parameter Exact numerics bit TYPES.Bit Boolean ✓ ✓ tinyint TYPES.TinyInt Number ✓ ✓ smallint TYPES.SmallInt Number ✓ ✓ int TYPES.Int Number ✓ ✓ bigint TYPES.BigInt String ✓ ✓ numeric TYPES.Numeric Number ✓ ✓ decimal TYPES.Decimal Number ✓ ✓ smallmoney TYPES.SmallMoney Number ✓ ✓ money TYPES.Money Number ✓ ✓ Approximate numerics float TYPES.Float Number ✓ ✓ real TYPES.Real Number ✓ ✓ Date and Time smalldatetime TYPES.SmallDateTime Date ✓ ✓ datetime TYPES.DateTime Date ✓ ✓ datetime2 TYPES.DateTime2 Date ✓ ✓ datetimeoffset TYPES.DateTimeOffset Date ✓ ✓ time TYPES.Time Date ✓ ✓ date TYPES.Date Date ✓ ✓ Character Strings char TYPES.Char String ✓ ✓ varchar TYPES.VarChar String ✓ ✓ text TYPES.Text String ✓ ✓ Unicode Strings nchar TYPES.NChar String ✓ ✓ nvarchar TYPES.NVarChar String ✓ ✓ ntext TYPES.NText String ✓ - Binary Strings binary TYPES.Binary Buffer ✓ ✓ varbinary TYPES.VarBinary Buffer ✓ ✓ image TYPES.Image Buffer ✓ ✓ Other Data Types null TYPES.Null null ✓ ✓ TVP TYPES.TVP Object - ✓ UDT TYPES.UDT Buffer ✓ - uniqueidentifier TYPES.UniqueIdentifier String ✓ ✓ variant TYPES.Variant any ✓ - xml TYPES.xml String ✓ - Notes Constants
The TYPES value used in the constants column can be obtained like this.
var TYPES = require('tedious').TYPES
BigInt
Values are returned as a string. This is because values can exceed 53 bits of significant data, which is greater than a Javascript Number type can represent as an integer.
Numeric, Decimal
For input parameters, default precision is 18 and default scale is 0. Maximum supported precision is 19 atm.
VarChar, NVarChar
varchar(max) and nvarchar(max) are also supported.
UniqueIdentifier
Values are returned as a 16 byte hexadecimal string.
Note that the order of bytes is not the same as the character representation. See Using uniqueidentifier Data for an example of the different ordering of bytes.
Null parameter value
The value for a parameter of any supported data type may be null.
RetroSearch is an open source project built by @garambo
| Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4