I am using a MS SQL Server node to Insert data into a database.
First of all, I am not really sure what the ‘Columns’ parameter means in the node settings:
I am able to use it successfully, however, I always make sure the SQL Server column names are exactly the same as the N8N JSON column names. First question, is this field meant for the N8N/MSSQL/or Both column names?
My second question revolves around using spaces in these column names. Since spaces are allowed in both the N8N json and the MSSQL column names I wanted to use them for longer column names. However, I keep gettiing “Incorrect syntax” errors:
I tried a combination of using quotes and brackets to solve this issue, and while I was able to get rid of the error this way, I did not get any populated columns with data, any help would be kindly appreciated.