# MSSQL Node Parameter

**URL:** <https://discourse.nodered.org/t/mssql-node-parameter/42700>\
**Category:** General\
**Created:** [16 March 2021 08:16 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700 "2021-03-16T08:16:45Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eintracht00](https://avatars.discourse-cdn.com/v4/letter/e/3d9bf3/32.png) [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Post date:** [16 March 2021 08:16 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/1 "2021-03-16T08:16:46Z")

</div>

I use the MSSQL Node to transfer Data to my SQL Server.  
I want to use the parameters like this:  
 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/7/77126aa378733c769b3eec2062c5fc1d17a88851.png)  
but there comes an error. Is it maybe not posible to have in the name of the parameter a " **-**" or " **\_**"?

---

<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:** [16 March 2021 08:53 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/2 "2021-03-16T08:53:44Z")

</div>

Dash `-` is **not** valid in a parameter name.  
Underscore `_` is valid in a parameter name.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/8/b86a0d92f66fae5f4296ae946910fc24878c643b.png)

---

<div class="post-metadata">

**Author:** ![Eintracht00](https://avatars.discourse-cdn.com/v4/letter/e/3d9bf3/32.png) [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Post date:** [16 March 2021 08:58 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/3 "2021-03-16T08:58:11Z")

</div>

okay what about a dot "."?

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [16 March 2021 09:03 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/4 "2021-03-16T09:03:45Z")

</div>

Dots won't work either, they are used to separate object names.

Have a look at this:

> **[Database Identifiers - SQL Server](https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?redirectedfrom=MSDN&view=sql-server-ver15#rules-for-regular-identifiers)**
>
> Get acquainted with database identifiers. Learn about their collation, various classes, delimiting requirements, and naming rules.

---

<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:** [16 March 2021 09:04 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/5 "2021-03-16T09:04:37Z")

</div>

No. But perhaps you are not understanding the significance of the parameter name?

It is essentially what you would write after a `DECLARE` e.g. `DECLARE @myParam int`

Rules...

- A letter as defined by the Unicode Standard 3.2. The Unicode definition of letters includes Latin characters from a through z,  
from A through Z, and also letter characters from other languages.
- The underscore (\_), at sign (@), or number sign (#).

e.g...

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/c/3cbded75f5426e26388b1ef3f2a18d7858faf9b2.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:** [16 March 2021 09:07 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/6 "2021-03-16T09:07:06Z")

</div>

> [@Eintracht00](#):
>
> I want to use the parameters like this:

Why would you even attempt to use parameters like that? I think you are slightly mixed up - maybe some online SQL Server training would help you out? (strictly speaking, this question has nothing to do with node-red, its a SQL Server question TBF)

In simple terms, if your query works in SSMS it works in this node.

---

<div class="post-metadata">

**Author:** ![Eintracht00](https://avatars.discourse-cdn.com/v4/letter/e/3d9bf3/32.png) [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Post date:** [16 March 2021 09:11 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/7 "2021-03-16T09:11:11Z")

</div>

its just for seperate the object properties, they are build like a tree.  
and i got in some parameters an underscore and a dot was for seperating objects thats why i went the way with the Dash. But i think i do it then with the hash.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [30 March 2021 09:11 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700/8 "2021-03-30T09:11:25Z")

</div>

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