jt-mssql
Description
This extension based on node-mssql
see tedious node-mssql for more detail.
version
1.0.6
usage
npm install jt-mssql -save
Example
Request
asyncQuery(command,params)
Call query Command by Async ( 异步 方法调用 query)
Arguments
- command (String) - T-SQL command to be executed.(执行的 sql 语句)
- params (Array/Object) - T-SQL params values (sql 语句中的参数值对象)
Params Only Support Below Formatter(params 只支持下面的数据格式)
params1 = id: 1 name: "jack" ;params2 = 1 2 3 4;params3=id:1,schoolId:1234;
** Example**
;
asyncInsert([command?:String],[params?:Array])
Call Insert Command by Async ( 异步方法调用 Insert)
Arguments
- command - T-SQL command to be executed.(执行的 sql 语句)
- params - T-SQL params values (sql 语句中的参数值对象)
** Params Only Support Below Formatter (params 只支持下面的数据格式)**
params1 = id: 1 name: "jack" id: 2 name: "mike" ;
Example
;});
Transaction
asyncBegin([isolationLevel?:obj], [callback?:async Func])
Async begin Transaction (异步 方法调用 query)
Arguments
- isolationLevel - Controls the locking and row versioning behavior of TSQL statements issued by a connection. Optional.
READ_COMMITTED
by default. For possible values seesql.ISOLATION_LEVEL
.查看 node-mssql - callback(err) - An Async callback which is called after transaction has began;(异步回调方法)
Example
;