Bulk Insert into MSSQL-Plus Node

Hello Everyone,

I am trying to perform a bulk insert into MSSQL-Plus Node that way I only run 1 connection rather than 100's. I have 100's of possible inserts each containing multiple values so I kept on getting ECONN errors because to many were trying to insert before the last one was complete. So I have an array of objects that I want to insert into sql each object being its own row in sql. Could someone help me create just as simple insert into a test table with just this data?

[{"name": "Bob", "age": 20}, {"name": "Mike", "age": 15}]

If someone could figure out the bulk statement of this it would be very helpful

Have you looked at the other threads on the forum: Search results for 'mssql bulk ' - Node-RED Forum ?

Have you tried the built in bulk demo? (CTRL-I -> examples -> node-red-contrib-mssql-plus) ?
If that is not showing for you then they are here: https://github.com/bestlong/node-red-contrib-mssql-plus/tree/master/examples

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.