var node_mssql = require('node-mssql');

/* add configuration to query object */
var queryObj = new node_mssql.Query({
    host: '192.168.1.32\\DESKTOP-70LI671',	 // You can use 'x.x.x.x\\instance' to connect to named instance
    port: 1433,
    username: 'sa',
    password: 'root',
    database: 'test_skip_card'
});

/* set table name to operate */
queryObj.table('dbo.data');

/* set update query condition */
queryObj.where({
    'name_en': 'Stepan',
})

/* run update query and fetch response */
queryObj.select(function(results) {
    //  success callback
    console.log(results);
    console.log(results);
    if (result.length!=0 && 'Ustinov' == result[0].surname_en){
            console.log("True Password!!!");
            auth = true;
            userId = result[0].Card_ID;
          }

}, function(err, sql) {
    //  failed callback
    if(err)
        console.log(err);

    console.log(sql);
});