Skip to content

Instantly share code, notes, and snippets.

@MRdNk
Created August 2, 2012 19:09
Show Gist options
  • Save MRdNk/3239816 to your computer and use it in GitHub Desktop.
Save MRdNk/3239816 to your computer and use it in GitHub Desktop.
MS SQL Stored Procedure with named parameter. Node.js - msnodesql driver example.
var sqlParams = [];
var forenameParam = {
name: '@forename'
, type: 'int'
, value: 'Bob'
}
sqlParams.push(forenameParam);
Option 1>
conn.execute('spUser_GetUser', sqlParams, function (err, result) {
}
And...
Option 2>
conn.execute('spUser_GetUser', sqlParams, function (err, returnValue, result) {
}
@mutyalamaheshbabu
Copy link

this is
error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment