Basic Setup for using Tedious (TDS) in node.js

UsingTedious.js

var Connection = require('tedious').Connection
var Request = require('tedious').Request
var TYPES = require('tedious').TYPES

var config = {
    userName: 'Username'
  , password: 'password'
  , server: 'localhost'
}

var connection = new Connection(config)
connection.on ('connect', function (err) {
  if (err) {
    console.error('Connection failed: ', err) 
    cb(err)
  }
  execute()
})

function execute () {
  var request = new Request('dbo.spStoredProcedureName', function (err) {
    if (err) {
      console.error('dbo.spStoredProcedureName: ', err)
      connection.close()
      cb(err)
    }
  })

  request.addParameter('ParameterName', TYPES.Int, id)
  request.on ('error', function (err) {
    console.error('request.on error: ', err)
    connection.close()
    cb(err)
  })
  request.on ('row', function (columns) {
    cb(null, columns)
  })
  connection.callProcedure(request)
}