UPDATED: node-red-contrib-mssql-plus 0.5.0

Big update completed, beta tested and now published to NPM.

V0.5.0 New Features

Parameters

It is now possible to include parameters in a query. These can be entered in the updated UI or passed in via msg , flow , global etc.
The major benefit of parameters is the protection against SQL Injection attacks

Execute mode

It is now possible to call native execute method to run stored procedures. This includes the possibility of using TVPs (Table Valued Parameters)

Info output

Any print or messages will now appear in the msg object

Demo

A demo flow has been added to the node-red imports dialog. It demonstrates the various ways of sending parameters to the MSSQL node. It also demonstrates TVP parameter usage.

Screenshot of UI changes.

6 Likes