var express = require('express');
var app = express();

    var sql = require("mssql");

    // config for your database
    var config = {
        user: 'user',
        password: 'someth',
        server: 'svr10', 
        database: 'Test',
        options: {
		enableArithAbort: false
            }

    };

    sql.connect(config, function (err) {
    
        if (err) console.log(err);

        // create Request object
        var request = new sql.Request();
           
        // query to the database and get the records
        request.query('select top 10 FirstName from EM', function (err, recordset) {
            
            if (err) console.log(err)

	   recordset.recordsets[0].forEach(element => console.log(element.FirstName));

        });
   });

//var express = require('express');
//var app = express();

   
var sql = require("mssql");

// config for your database
//Vision_Prod;uid=rsuser;pwd=someth!4!noth;
var config = {
      user: 'rsuser',
      password: 'someth!4!noth',
      server: 'edm-svr10', 
      database: 'Vision_Test',
      options: {
	enableArithAbort: true
      }

};

// print process.argv
process.argv.forEach(function (val, index, array) {
  console.log(index + ': ' + val);
});

sql.connect(config, function (err) {
    
    if (err) console.log(err);

    // create Request object
     var request = new sql.Request();
           
     // query to the database and get the records
     request.query('select top 10 FirstName from EM', function (err, recordset) {
            
         if (err) console.log(err)

	   recordset.recordsets[0].forEach(element => console.log(element.FirstName));

     });
});