How Do I Get Data From PAC to Node-RED to MS SQL Server

[born2see]

Here is a pretty extensive thread that I was involved in:

How to Update a MSSQL Database with Node-RED

OK. So that works and I’m beginning to see the light although it’s pretty dim. Please explain this to me: [image] Why are there double quotes and a carriage return. I assume the CR is there to tell the SQL server to add or update another record. Why the " " ?. Would those not be there if I’m updating/inserting numbers? That doesn’t seem to be the case as these are floats: [image]