Need help - Syntax MSSQL Insert Statement from a msg.payload

General
1

Hello,

what ist the generell Syntax fo executing a MSSQL insert statement from a msg.payload? I've installed the mssql node. with a fixed value works I have success..

Thank you
jo

2

Which MSSQL node have you installed? There are a few in the library.

I would assume you provide the SQL statement as a string in msg.payload, and leave the field blank in the node itself.

What have you tried so far?

3

i've installed the node-red-node-mysql. A simple template node with "INSERT INTO w1-power-keller (power) VALUES ('111');" works. instead of 111 I would like to have a value from a msg. payload.

Thank you

4

If you look at the info tab for the template node it shows you how to insert msg.payload into the result.