"get": function (req, res, next) {
     var sql = require("mssql");

var config = {
    server: 'LOCALHOST\SQLEXPRESS',
    user: 'sa',
    password: 'pass1009',
    database: 'smartpointmovil_db',
    port: 1433
};


var conn = new sql.Connection(config);
var req=new sql.Request(conn);

  conn.connect(function(err){
      if(err){
           console.log("Error connectig: "+err);
           return;
      }


      req.query('select * from smartpointmovil.cat_cadenas where id=1',function(err,results){
                    if(err){
                           console.log("Error during query: "+err);
                           return;
                           }
                    else{
                          console.log("Success: "+results[0].cadena);
                          res.json(results[0]);
                         }
                    conn.close();
      });

  });