nodeでsql serverに接続する

(mssql.query.js)

#!/usr/bin/env node

const sql = require('mssql');
var config = {
  user: 'sa',
  password: '******',
  server: '******', // You can use 'localhost\\instance' to connect to named instance
  database: 'AdventureWorks2017',
  stream: true, // You can enable streaming globally

  options: {
//    encrypt: true // Use this if you're on Windows Azure
//    encrypt: false// Use this if you're on Windows Azure
  }
}

sql.connect(config, function(err) {

  const request = new sql.Request();
  request.stream = true
  request.query('select * from adventureworks2017.HumanResources.Department')

  request.on('row', row => {
    console.log(row);
  });

  request.on('done', result => {
    process.exit();
  });

});

実行してみる

$ ./mssql.query.js 
{ DepartmentID: 1,
  Name: 'Engineering',
  GroupName: 'Research and Development',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 2,
  Name: 'Tool Design',
  GroupName: 'Research and Development',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 3,
  Name: 'Sales',
  GroupName: 'Sales and Marketing',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 4,
  Name: 'Marketing',
  GroupName: 'Sales and Marketing',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 5,
  Name: 'Purchasing',
  GroupName: 'Inventory Management',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 6,
  Name: 'Research and Development',
  GroupName: 'Research and Development',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 7,
  Name: 'Production',
  GroupName: 'Manufacturing',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 8,
  Name: 'Production Control',
  GroupName: 'Manufacturing',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 9,
  Name: 'Human Resources',
  GroupName: 'Executive General and Administration',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 10,
  Name: 'Finance',
  GroupName: 'Executive General and Administration',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 11,
  Name: 'Information Services',
  GroupName: 'Executive General and Administration',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 12,
  Name: 'Document Control',
  GroupName: 'Quality Assurance',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 13,
  Name: 'Quality Assurance',
  GroupName: 'Quality Assurance',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 14,
  Name: 'Facilities and Maintenance',
  GroupName: 'Executive General and Administration',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 15,
  Name: 'Shipping and Receiving',
  GroupName: 'Inventory Management',
  ModifiedDate: 2008-04-30T00:00:00.000Z }
{ DepartmentID: 16,
  Name: 'Executive',
  GroupName: 'Executive General and Administration',
  ModifiedDate: 2008-04-30T00:00:00.000Z }

参考:
https://www.npmjs.com/package/mssql