从Node.js连接到SQL Server数据库

npm install tedious

const Connection = require('tedious').Connection;
const Request = require('tedious').Request;

const config = {
  server: 'your-server-name',
  authentication: {
    type: 'default',
    options: {
      userName: 'your-username',
      password: 'your-password'
    }
  },
  options: {
    database: 'your-database-name',
    encrypt: true
  }
};

const connection = new Connection(config);

connection.on('connect', err => {
  if (err) {
    console.error(err.message);
  } else {
    console.log('Connected to SQL Server');
  }
});

connection.connect();

const query = 'SELECT * FROM your-table-name';

const request = new Request(query, err => {
  if (err) {
    console.error(err.message);
  }
});

request.on('row', columns => {
  columns.forEach(column => {
    console.log(`${column.metadata.colName}: ${column.value}`);
  });
});

connection.execSql(request);

node your-file-name.js