Insert new record into MSSQL

[Steve-Mcl]

@dpenz

and what should the INSERT statement look like

It should look exactly like you want it.

Example..

INSERT INTO test_data.settings 
( [test_run#], [pump_type], [etc] ) 
VALUES ( 
  @param1, 
  @param2, 
  @param3
)

where @param1 ~ @param3 are entered in the "parameters" section & mapped to the correct property in the msg and set for the intended type.

Here is a couple of threads that explain how:

• Logging data in to MSSQL - #13 by Steve-Mcl
• SQL data return array data types? MSSQL Node - #3 by Steve-Mcl
• and more