Big update completed, beta tested and now published to NPM.
V0.5.0 New Features
It is now possible to include parameters in a query. These can be entered in the updated UI or passed in via
The major benefit of parameters is the protection against SQL Injection attacks
It is now possible to call native
execute method to run stored procedures. This includes the possibility of using TVPs (Table Valued Parameters)
Any print or messages will now appear in the
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.