const sql = require('mssql')
let a

const config = {
    user: 'webapi',
    password: 'Resengineer1!',
    server: 'n201704091930.cwcd2a7ocpex.ap-southeast-1.rds.amazonaws.com', // You can use 'localhost\\instance' to connect to named instance
     database: 'FoodDbContext',
    port : '1433'
}

var results =[];

sql.connect(config, err => {
    // ... error checks

    const request = new sql.Request()
    request.stream = true
    request.query('select top(1000) * from Expenses Where CustomerId = 4073 Order By Id')

    request.on('recordset', columns => {
        debugger
    })

    request.on('row', row => {

        results.push(row)

    })

    request.on('error', err => {

    })

    request.on('done', result => {
        console.log(" DONE")
        console.log("lengths : ",  results.length)
    })
})

sql.on('error', err => {
    // ... error handler

    debugger;

})