var Connection = require("tedious").Connection;
var Request = require("tedious").Request;

// Create connection to database
var config = {
  userName: "insert username",
  password: "insert password",
  server: "insert server",
  options: {
    database: "insert database name",
    encrypt: true
  }
};
var connection = new Connection(config);

// Attempt to connect and execute queries if connection goes through
connection.on("connect", function(err) {
  if (err) {
    console.log(err);
  } else {
    console.log("Connected to SQL database!");
    queryDatabase();
  }
});

function queryDatabase() {
  console.log("Reading rows from the Table...");

  // Read all rows from table
  request = new Request("SELECT * from <insert name of existing datatable from database", function(
    err,
    rowCount,
    rows
  ) {
    console.log(rowCount + " row(s) returned");
    process.exit();
  });

  request.on("row", function(columns) {
    columns.forEach(function(column) {
      console.log("%st%s", column.metadata.colName, column.value);
    });
  });
  connection.execSql(request);
}

request.on("row", function(columns) {
    var output = [];
    columns.forEach(function(column) {
      output.push("{0}t{1}".format(column.metadata.colName, column.value));
    });
     res.writeHead(200, {'Content-Type': 'application/json'});
     res.write(JSON.stringify(output))
     res.end();
  });