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