如何使用Sequelize调用MSSQL存储过程？

npm install sequelize
npm install tedious

const Sequelize = require('sequelize');
const { Connection, Request } = require('tedious');

const sequelize = new Sequelize('database', 'username', 'password', {
  dialect: 'mssql',
  host: 'localhost',
  port: 1433,
  dialectOptions: {
    options: {
      encrypt: true, // 如果使用的是加密连接，需要设置为true
    },
  },
});

const Procedure = sequelize.define('Procedure', {}, { timestamps: false });

sequelize.query('EXEC your_procedure_name', { type: sequelize.QueryTypes.SELECT })
  .then((results) => {
    // 处理存储过程的返回结果
    console.log(results);
  })
  .catch((error) => {
    // 处理错误
    console.error(error);
  });