# Can't upload some values to MSSQL

**URL:** <https://discourse.nodered.org/t/cant-upload-some-values-to-mssql/53931>\
**Category:** General\
**Tags:** database\
**Created:** [18 November 2021 10:50 UTC](https://discourse.nodered.org/t/cant-upload-some-values-to-mssql/53931 "2021-11-18T10:50:06Z")\
**Posts on this page:** 1\
**Showing post:** 15

<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:** [21 November 2021 19:05 UTC](https://discourse.nodered.org/t/cant-upload-some-values-to-mssql/53931/15 "2021-11-21T19:05:52Z")

</div>

If you have the `query` set to `editor` you cannot pass a query into the node.

What I was saying in the previous post was to use the parameters.

Here is an example that explains how it works...

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/d/1d2459e142c221d28c4b1fb32cbd228d94e36787.png)

---

_[View the full topic](https://discourse.nodered.org/t/cant-upload-some-values-to-mssql/53931)._