TypeError: request.callback不是使用Node和SQLServer的函数

const express = require('express');
const app = express();
const sql = require('mssql');

app.get('/data', (req, res) => {
    const request = new sql.Request();
    request.query('SELECT * FROM your_table', (err, result) => {
        if (err) {
            console.error(err);
            res.status(500).send('Internal Server Error');
        } else {
            res.json(result.recordset);
        }
    });
});

app.listen(3000, () => {
    console.log('Server is running on port 3000');
});

const express = require('express');
const app = express();
require('express-async-errors');
const sql = require('mssql');

app.get('/data', async (req, res) => {
    try {
        const pool = await sql.connect('mssql://username:password@server/database');
        const result = await pool.request().query('SELECT * FROM your_table');
        res.json(result.recordset);
    } catch (err) {
        console.error(err);
        res.status(500).send('Internal Server Error');
    }
});

app.listen(3000, () => {
    console.log('Server is running on port 3000');
});

npm install mssql@latest