# Mssql insert statement

**URL:** <https://discourse.nodered.org/t/mssql-insert-statement/1990>\
**Category:** General\
**Created:** [2 August 2018 00:29 UTC](https://discourse.nodered.org/t/mssql-insert-statement/1990 "2018-08-02T00:29:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![thiren](https://avatars.discourse-cdn.com/v4/letter/t/48db29/32.png) [@thiren](https://discourse.nodered.org/u/thiren)\
**Post date:** [2 August 2018 00:29 UTC](https://discourse.nodered.org/t/mssql-insert-statement/1990/1 "2018-08-02T00:29:15Z")

</div>

> node-red-contrib-mssql  
> node-red-node-mssql

1. Hi Which above node I can use for stable DB connection request?
  - Currently I'm going to inject around 400 insert statement in mssql.

2. What is the best way should I do to avoid request time out while inserting?

---

<div class="post-metadata">

**Author:** ![realjax](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/realjax/32/895_2.png) [@realjax](https://discourse.nodered.org/u/realjax)\
**Post date:** [2 August 2018 07:57 UTC](https://discourse.nodered.org/t/mssql-insert-statement/1990/2 "2018-08-02T07:57:56Z")

</div>

How about 400 rows in one insert statement? Is probably your best option.

---

<div class="post-metadata">

**Author:** ![shrickus](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/shrickus/32/517_2.png) [@shrickus](https://discourse.nodered.org/u/shrickus)\
**Post date:** [3 August 2018 13:34 UTC](https://discourse.nodered.org/t/mssql-insert-statement/1990/3 "2018-08-03T13:34:01Z")

</div>

The nodes named `node-red-node-*` were/are created/maintained by the Node-RED team, as optional "core" nodes that are not necessarily part of the default install. As their quality and adherence to the expected node-red programming style are proven, I prefer to use them before using the 3rd party contributed nodes. Sometimes the contrib node provides extra features, and is therefore the right choice -- and since they are all open source, you can look at the code and decide for yourself.

---

<div class="post-metadata">

**Author:** ![thiren](https://avatars.discourse-cdn.com/v4/letter/t/48db29/32.png) [@thiren](https://discourse.nodered.org/u/thiren)\
**Post date:** [6 August 2018 23:34 UTC](https://discourse.nodered.org/t/mssql-insert-statement/1990/4 "2018-08-06T23:34:38Z")

</div>

You are great bro, you trigger me the idea. It's good idea inserting multiple row value with one Insert statement and it's work perfectly. Thank you.