A Sample To Fetch Data From MSSQL using Windows Authentication

fetch_data_from_sql_server.js

const msnodesql = require("msnodesqlv8");

async function fetchDataList(conn, query) {
    return new Promise((resolve, reject) => {
        conn.query(query, (err, rows) => {
            if (err !== null) {
                reject(err);
                return;
            }

            resolve(rows);
        });
    });
}

async function main() {
    const connectionString = "server=SERVER_NAME\\INSTANCE_NAME;Database=DATABASE_NAME;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}";
    msnodesql.open(connectionString, async (err, conn) => {
        const resultList = await fetchDataList(conn, 'select * from dbo.TABLE_NAME');
    }
}

main();