MSSQL Node Parameter

General
1

I use the MSSQL Node to transfer Data to my SQL Server.
I want to use the parameters like this:
grafik
but there comes an error. Is it maybe not posible to have in the name of the parameter a "-" or "_"?

2

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

image
image727×159 6.9 KB

3

okay what about a dot "."?

4

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

Have a look at this:

5

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
image833×239 10.8 KB

6

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.

7

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.

8

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