Add Execute mode and support Parameters
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.
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)
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.