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.