# Bulk Insert into MSSQL-Plus Node
**URL:** https://discourse.nodered.org/t/bulk-insert-into-mssql-plus-node/80777
**Category:** General
**Created:** [24 August 2023 16:52 UTC](https://discourse.nodered.org/t/bulk-insert-into-mssql-plus-node/80777 "2023-08-24T16:52:12Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@KAMERONSWENSON](https://discourse.nodered.org/u/KAMERONSWENSON)
#### Post date: [24 August 2023 16:52 UTC](https://discourse.nodered.org/t/bulk-insert-into-mssql-plus-node/80777/1 "2023-08-24T16:52:12Z")
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
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [26 August 2023 14:48 UTC](https://discourse.nodered.org/t/bulk-insert-into-mssql-plus-node/80777/2 "2023-08-26T14:48:24Z")
Have you looked at the other threads on the forum: [Search results for 'mssql bulk ' - Node-RED Forum](https://discourse.nodered.org/search?q=mssql%20bulk%20) ?
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](https://github.com/bestlong/node-red-contrib-mssql-plus/tree/master/examples)_
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [25 October 2023 14:49 UTC](https://discourse.nodered.org/t/bulk-insert-into-mssql-plus-node/80777/3 "2023-10-25T14:49:17Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.