var Connection = require('tedious').Connection;
var Request = require('tedious').Request;
var ted_select = "query";

var config = {
    userName: 'name',
    password: 'pass',
    server: 'servername',
    options: {database : 'dbname'}
  };

function tedious_select(query) {
    var res = [];
    var connection = new Connection(config);

    var conn = connection.on('connect', function(err) {
      if (err) {
        console.log(err);
      } else {
          console.log('Connect database');
          request = new Request(query, function(err) {
              if (err) {
                  console.log(err);
              }
          });

          request.on('row', function(columns) {
              columns.forEach(function(column) {
                  if (column.isNull) {
                      res[column.metadata.colName] = null;
                  } else {
                      res[column.metadata.colName] = column.value;
                  }
              });
              console.log(res);
          });
          connection.execSql(request);
          setTimeout(function(){connection.close(console.log('Disconnect database'));},10000);
      }
    });
}

var select = tedious_select(ted_select);
console.log(select);