# Can Node Mssql running in many flow?
**URL:** https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954
**Category:** General
**Created:** [17 December 2024 09:25 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954 "2024-12-17T09:25:24Z")
**Posts on this page:** 19
**Page:** 1
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [17 December 2024 09:25 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/1 "2024-12-17T09:25:24Z")
Can this mssql node run if installed in 1 flow? if for example I have 9 flows then there will be 9 mssql nodes running at the same time
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 December 2024 12:46 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/2 "2024-12-17T12:46:16Z")
> [@riimeister](#):
>
> this mssql
Which one. There is the old, unmaintained , buggy, feature-less `node-red-contrib-mssql` and there is the buch better , more stable, more capable, maintained `node-red-contrib-mssql-plus` (and a few others)
> [@riimeister](#):
>
> if for example I have 9 flows then there will be 9 mssql nodes running at the same time
You could, but if they operate at exactly the same time you might run into concurrency issues due to lack of transactions.
The better solution would be to put one mssql node inside of a subroutine (using link nodes and the link-call node)
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 01:08 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/3 "2024-12-18T01:08:39Z")
currently i use node-red-contrib-mssql and will probably move to mssql-plus
hmm, what is an example of a link node for calling and inputting MSSQL?
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 02:52 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/4 "2024-12-18T02:52:15Z")
link out and link in like this? looks like it works
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [18 December 2024 05:32 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/5 "2024-12-18T05:32:04Z")
This is the concept:
1. link-in node. Make sure to give it a proper name (eg. db)
2. link-out node. Set the mode to: 'return to calling link node'
3. link-call node. select the name you gave to 1.
Now you can pass a query and call the db directly in your flows by only using the link-call node.
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 06:30 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/6 "2024-12-18T06:30:21Z")
I made it like this, is it working properly?
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [18 December 2024 06:33 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/7 "2024-12-18T06:33:37Z")
'Usually' you want to do something with the output of your query, this is the reason why it is suggested to use a link-call node so that you can process the output - as the output is returned.
Now you are performing queries, but you don't know if they were successful or not.
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 06:37 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/8 "2024-12-18T06:37:57Z")
can you send me an example of the flow you created? so I can test it and see the difference with the one I created
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [18 December 2024 06:38 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/9 "2024-12-18T06:38:53Z")
The example shows an explanation how to do it, you should be able to replicate it.
The 'query' node in the screenshot will contain the query and should be set to `msg.query`
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 06:52 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/10 "2024-12-18T06:52:30Z")
what settings are set in mssql-plus node?
---
### Author:  [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)
#### Post date: [18 December 2024 06:52 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/11 "2024-12-18T06:52:43Z")
Similar setup I have for MySQL Node. I also have a rate limit node before as sometimes in my flow, there is a sudden surge of queries and it helps control the same.
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [18 December 2024 06:54 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/12 "2024-12-18T06:54:25Z")
I use these settings
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 06:58 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/13 "2024-12-18T06:58:22Z")
I think the flow I created like this works because the debug results show that the data is sent to the SQL database.
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 07:01 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/14 "2024-12-18T07:01:37Z")
aaaahh alright, can i see the configuration of that node? for comparison
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [18 December 2024 07:02 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/15 "2024-12-18T07:02:53Z")
Ok how do you keep track of the output that is generated (ie. was the insert successful ? and what if it fails?) and what do you do with the output ?
A typical flow is: data in \> process \> data out \> do something with the output
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [18 December 2024 07:06 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/16 "2024-12-18T07:06:34Z")
for now, track it with the debug function results that show the insert into was successful and do a check in the SQL Server database, is there anything missing in this step?
---
### Author:  [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)
#### Post date: [18 December 2024 11:21 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/17 "2024-12-18T11:21:27Z")
here you go.. may not be comparable to MSSQL node though.
---
### Author:  [@riimeister](https://discourse.nodered.org/u/riimeister)
#### Post date: [19 December 2024 06:16 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/18 "2024-12-19T06:16:04Z")
problem solved guys, thank u for help me!! @Steve-Mcl @bakman2 @smanjunath211 using Link node its works!!
input from 70 mqtt machine to mssql in the same time hahah
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [19 March 2025 06:16 UTC](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/19 "2025-03-19T06:16:34Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.