read db

nodejs-sql.js

const sql = require('mssql')
const config = {
    user: '',
    password: '',
    server: '', // You can use 'localhost\\instance' to connect to named instance
    database: '',
 
    options: {
        encrypt: true // Use this if you're on Windows Azure
    }
}
async function test() {

    var queryString = "select * from activities"
    const pool = new sql.ConnectionPool(config).connect();
    var conn = await pool
    
    const req =  conn.request();
    const result = await req.query(queryString)
    var returnValue = result['recordset'][0]['Name']
    pool.close()

    return returnValue

}
try{
    test()
}catch(err)
{
    console.log(err.message)
}