# MSSQL-PLUS Execute Procedure

**URL:** <https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377>\
**Category:** General\
**Tags:** node-red-contrib-mssql-plus\
**Created:** [7 August 2023 13:24 UTC](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377 "2023-08-07T13:24:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohamed\_1711](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@Mohamed\_1711](https://discourse.nodered.org/u/Mohamed_1711)\
**Post date:** [7 August 2023 13:24 UTC](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377/1 "2023-08-07T13:24:34Z")

</div>

I Have function before my MSSQL-PLUS I want to send to MSSQL-PLUS the

1. procedure Name : ProductNodeRedService  
And this procedure has 3 parameters and 2 return Value :  
Paramter\_Number\_1 Type: NVARCHAR(MAX)  
Paramter\_Number\_1 Value : '101859,2034,2222,3333,666'

Paramter\_Number\_2 Type: INT  
Paramter\_Number\_2 Value :0

Paramter\_Number\_3 Type: INT  
Paramter\_Number\_3 Value :2

And there is 2 return values from this procedure  
and  
I want to see both returned value because depend on it I choose the path of my code

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [7 August 2023 13:34 UTC](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377/2 "2023-08-07T13:34:00Z")

</div>

Salam alaykum @Mohamed_1711, welcome to the forum.

Does the database procedure run?

Please show us the output.  
(Use a debug node set to show the entire message object, the "Copy value button in the debug panel and post it here using the `</>` button.)

---

<div class="post-metadata">

**Author:** ![Mohamed\_1711](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@Mohamed\_1711](https://discourse.nodered.org/u/Mohamed_1711)\
**Post date:** [8 August 2023 05:16 UTC](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377/3 "2023-08-08T05:16:16Z")

</div>

The procedure Run and  
return output type integer by mean return = 2

---

<div class="post-metadata">

**Author:** ![tree-frog](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/tree-frog/32/89303_2.png) [@tree-frog](https://discourse.nodered.org/u/tree-frog)\
**Post date:** [11 August 2023 23:46 UTC](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377/4 "2023-08-11T23:46:34Z")

</div>

you can select how you want to receive the return values. Please take a minute and read the configuration. Also the best way to get this working the way you intend is to ensure that you can model your queries, procedures, responses etc in SQL Server Management Studio (SSMS). Then pass the SQL statement with the node.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [10 October 2023 23:46 UTC](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377/5 "2023-10-10T23:46:47Z")

</div>

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