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

var config = {
    user: 'username',
    password: 'password',
    server: 'localhost',
    database: 'mydatabase'
};

var query_result;

sql.connect(config).then(pool => {
    return pool.request()
    .query('select * from test')
}).then(result => {
    console.dir(result); //here it logs the results
    query_result = result.recordset;
});

console.dir(query_result) // here it logs "undefined"

/* GET home page. */
router.get('/', function(req, res, next) {
    res.render('index',
        {
            result: query_result
        }
    );
});

module.exports = router;