node-red-contrib-mssql-ps 1.2.5

Execute MSSQL Prepared Statements from Node-RED

npm install node-red-contrib-mssql-ps

This node was created to execute prepared statements from Node-RED using the node.js node mssql. Pass in the parameters for the prepared statement as an object in msg.params Ex:

msg.params = {
    id:1,
    name:"John Doe"
}

Parameter object names must match parameters set up in the Prepared Statement and can be any string. Depending on the parameter type selected there may be options required. In the SQL Statement reference parameters by using @(parameter name) Ex:

SELECT *
FROM users
WHERE userid = @id OR name = @name;

Node Info

Version: 1.2.5
Updated 6 years ago
License: MIT
Rating: not yet rated

Actions

Rate:

Downloads

2 in the last week

Nodes

  • node-red-contrib-mssql-ps
  • mssql-ps-serverconf

Keywords

  • node-red
  • MSSQL
  • Prepared Statement

Maintainers