# Extracting a value from an MS-SQL database

**URL:** <https://discourse.nodered.org/t/extracting-a-value-from-an-ms-sql-database/61228>\
**Category:** General\
**Tags:** database\
**Created:** [13 April 2022 09:36 UTC](https://discourse.nodered.org/t/extracting-a-value-from-an-ms-sql-database/61228 "2022-04-13T09:36:44Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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 April 2022 09:17 UTC](https://discourse.nodered.org/t/extracting-a-value-from-an-ms-sql-database/61228/6 "2022-04-14T09:17:41Z")

</div>

Please be aware that this can be susceptible to SQL Injection.

For safety, it is always better to use Stored Procedures or Parameters

#### Using node-red-contrib-mssql-plus...

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

---

_[View the full topic](https://discourse.nodered.org/t/extracting-a-value-from-an-ms-sql-database/61228)._