Node.js MSSQL CRUD Tutorial

• Read Data from MSSQl DB using NodeJS

var webconfig = {

    user: 'login',

    password: 'sa@123',

    server: 'localhost', 

    database: 'TestDB',

    

    options: {

        encrypt: false // Use this if you're on Windows Azure 

    }

}

var express = require('express');

var sql = require('mssql');

var http = require('http');

var app = express();

var port = process.env.PORT || 8000;

var connection = new sql.Connection(webconfig, function(err) {

    var request = new sql.Request(connection); 

    request.query('select * from Employees', function(err, recordset) {

       if(err)      // ... error checks 

            console.log('Database connection error');

        

    console.dir("User Data: "+recordset);

    });

});

app.listen(port);

console.log(port+' is the magic port');

• Create(Insert) Data into MSSQL DB from NodeJS

request.query("insert into Employee
(EmpId,EmpName,EmpGender)   values ('400','Raman','Male')").then(function(res) {

                  console.dir("User Data: "+res);
}).catch(function(err){
                 console.log('Database connection error' +err);
});

});

• Update Record from NodeJS

request.query("update Employee SET EmpName='Akash' where EmpId='500'").then(function(res) {

console.dir("User Data: "+res);
}).catch(function(err){

console.log('Database connection error' +err);
});

Node.js basic MSSQL Connection Tutorial with mssql

Node.js Tutorial

Below is sample node.js program which will connect node.js application with MSSQL server.

//Create a JavaScript file index.js or app.js 

var webconfig = {

    user: 'login',

    password: 'sa@123',

    server: 'localhost', 

    database: 'TestDB',

    

    options: {

        encrypt: false // Use this if you're on Windows Azure 

    }

}

var express = require('express');

var sql = require('mssql');

var http = require('http');

var app = express();

var port = process.env.PORT || 8000;

var connection = new sql.Connection(webconfig, function(err) {

    var request = new sql.Request(connection); 

    request.query('select * from Users', function(err, recordset) {

       if(err)      // ... error checks 

            console.log('Database connection error');

        

    console.dir("User Data: "+recordset);

    });

});

app.listen(port);

console.log(port+' is the magic port');