Hello, Thanks a lot for the help and information. I tried working with the small functions and now I did able to successfully select the data, tried dynamic values. But I am still not able to understand the mustache format and how to use it.
In MSSQL, I successfully copied the CSV data to my table by writing queries in MSSQL but when I am using the same in node red, I am getting some syntax errors.
The query in my MSSQL is as follows-
BULK INSERT dbo.TEST_City_Data
FIRSTROW = 2,
FIELDTERMINATOR = ',', --CSV field delimiter
ROWTERMINATOR = '\n', --Use to shift the control to next row
This is working perfect in MSSQL .
But while transferring the same into node red MSSQL node, I am getting errors. How should i proceed?
Thanks a lot