Node-mssql-helper NPM

Node MSSQL Helper

GitHub

Node MSSQL Helper is a NPM library for call Query and Store Procedure from MSSQL server.

Installation

npm install --save node-mssql-helper

yarn add node-mssql-helper

Usage

import NodeMSSQLHelper from 'node-mssql-helper';

// Init a instances of module
const configDB = {
      user: '...',
      password: '...',
      server: '...',
      database: '...',
};

const connect = new NodeMSSQLHelper(configDB);

// Call a query

const results = await connect.Query('SELECT * FROM tableName ....',param1, param2, param3, ....);

// Call a Store Procedure
const results = await connect.ExecProc(procedureName, param1, param2, param3, ....);