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

**URL:** <https://discourse.nodered.org/t/updated-node-red-contrib-mssql-plus-0-5-0/31586>\
**Category:** Share Your Nodes\
**Created:** [15 August 2020 15:09 UTC](https://discourse.nodered.org/t/updated-node-red-contrib-mssql-plus-0-5-0/31586 "2020-08-15T15:09:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 August 2020 15:09 UTC](https://discourse.nodered.org/t/updated-node-red-contrib-mssql-plus-0-5-0/31586/1 "2020-08-15T15:09:40Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/a/ca06b0d4c7774c1013c8c8132a0e7a06d1326da5.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [14 October 2020 15:09 UTC](https://discourse.nodered.org/t/updated-node-red-contrib-mssql-plus-0-5-0/31586/2 "2020-10-14T15:09:46Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.