Node JS service using MSSQL server.

Here I will explain how to connect sql database in node js service.
you can call this service from angular js, jquery etc.

we require express and mssql packages for this.

 First of all we attach require packages. you have download this packages using npm in your project.

var express = require('express'),
    app = express();
var sql = require('mssql');

Then after configure your database credentials.

var config = {
    user: 'USERNAME',
    password: 'PASSSWORD',
    server: 'SERVER IP', 
    database: 'DBNAME',
    pool: {
        max: 100,
        min: 0,
        idleTimeoutMillis: 3000000
    },
    options: {
        encrypt: true
    }
};

Here I have created object of sql connection and call connect method of this.

var connection = new sql.Connection(config);
connection.connect();

here i have created get method.

app.get('/Your service name', function (req, res) {
    
    //attach header for cross platform request
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept");
    //add your parameter here
    var par1 = req.param('par1');
    var par2 = req.param('par2');
    var par3 = req.param('par3');
    new sql.Request(connection)
    .input('par1', sql.VarChar(50), par1)
    .input('par2', sql.VarChar(50), par2)
    .input('par3', sql.VarChar(50), par3)
    .execute('Your stored procedure name').then(function (recordsets) {
        res.send(recordsets);
        res.end();
    }).catch(function (err) {
        console.log(err);
    });
})

This service is run on 6248 port on local server.

var server = app.listen(6248, function () {
    console.log('Server Run On 6248 Port');
});