app.get('/', function (req, res) {
var sql = require("mssql/msnodesqlv8");
    //var sql = require('mssql');
    var config = {
        driver: 'msnodesqlv8',
        server: 'localhost',
        database: 'TestDB',
        options: {
            trustedConnection: true,
            useUTC: true
        }
    }

    sql.connect(config).then(function () {
         console.log("welcome");
        new sql.Request().query('select * from Company')

        .then(function (recordset) {
            // console.log(recordset);
            res.send(recordset);
        }).catch(function (err) {
            console.log(err);
        });

    }).catch(function (err) {
        console.log(err);
    });
    //sql.end();
});

app.get('/srv', function (req, res) {

   var sql = require("mssql/msnodesqlv8");
    //var sql = require('mssql');
    var config1 = {
       // driver: 'msnodesqlv8',
        server: 'localhost',
        database: 'TestingDB',
        user: 'sa',
        password: '',
        //options: {
        //    trustedConnection: true,
        //    useUTC: true
        //}
    }
    sql.connect(config).then(function () {
         console.log("Server data");
        new sql.Request().query('select * from Employee')
        .then(function (recordset) {
            // console.log(recordset);
            res.send(recordset);
        }).catch(function (err) {
            console.log(err);
        });

    }).catch(function (err) {
        console.log(err);
    });
    });