mssql from node

index.js

const sql = require('mssql')
const connstring = "mssql://wadezig:[email protected]/dbnamehere?encrypt=true"

const test = async function (context, req) {
    let pool = await sql.connect(connstring)
    let result = await pool.request()
        .input('from', sql.VarChar(255), 'fromval')
        .input('to', sql.VarChar(255), 'toval')
        .query('insert into referrer (url_from, url_to) values (@from, @to)')

    return result;
}



test().then(console.log).catch(console.error)