Coerce a data value into a MSSQL bind-parameter value. node-mssql infers the SQL type
from the JS value (number, string, boolean, Date, Buffer), so most values pass through.
Binary columns are the exception: only a Buffer is inferred as VarBinary, so
Uint8Array and (base64-encoded) string values are converted to Buffer — otherwise they
would be bound as NVarChar and fail with "Implicit conversion from data type nvarchar to
binary is not allowed".
data value to bind
native type name for the table column
Connect to database.
Disconnect from database.
Resolve the optimal native (SQL) type for a serialized field schema.
serialized field schema
Get the schema fields of a table as OINODataFields (without any API-level field filtering).
name of the table
Get the names of all user (base) tables in the database schema, excluding system tables and views.
Parse a single SQL result value for serialization using the context of the native data type.
data from serialization
native type name for table column
Print a single data value from serialization using the context of the native data type with the correct SQL escaping.
data from sql results
native type name for table column
Print a column name with correct SQL escaping.
name of the column
Print a bind-parameter placeholder for the given zero-based parameter index (MSSQL @p0).
zero-based parameter index
Print SQL ADD COLUMN statement.
name of the table
field to add
Print SQL CREATE TABLE statement.
name of the table
fields of the table
Print SQL DROP COLUMN statement.
name of the table
name of the column
Print SQL DROP TABLE statement.
name of the table
Print SQL select statement with DB specific formatting.
The name of the table to select from.
The columns to be selected.
The values to be inserted.
OptionalreturnIdFields: string[]the id fields to return if returnIds is true (if supported by the database)
Print SQL select statement with DB specific formatting.
The name of the table to select from.
The columns to be selected.
The WHERE clause to filter the results.
The ORDER BY clause to sort the results.
The LIMIT clause to limit the number of results.
The GROUP BY clause to group the results.
Print a single string value as valid sql literal
string value
Print a table name using database specific SQL escaping.
name of the table
Execute a parameterized statement, binding its values as @p0, @p1, … named parameters.
statement (SQL text + ordered bind values) to execute
Execute other sql operations.
SQL statement.
Execute a select operation.
SQL statement.
Validate connection to database is working.
Implementation of MsSql-database.