# Node-red-contrib-mssql-plus Execute Procedure

**URL:** <https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985>\
**Category:** General\
**Tags:** database\
**Created:** [27 March 2023 11:57 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985 "2023-03-27T11:57:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![protonmw](https://avatars.discourse-cdn.com/v4/letter/p/b3f665/32.png) [@protonmw](https://discourse.nodered.org/u/protonmw)\
**Post date:** [27 March 2023 11:57 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985/1 "2023-03-27T11:57:53Z")

</div>

Hi all!

Could anyone give my an example of executing a stored procedure (with 2 parameters), please?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/1/313c329577b7c8023756bcf6120f3d0094ffbedf.png)  
gives me **msg.payload: undefined**

This is the working SQL studio code:

```auto
USE [xxx]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[Store_Procedure]
		@type = 14,
		@year = 23

SELECT	'Return Value' = @return_value

GO

```

---

<div class="post-metadata">

**Author:** ![GogoVega](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/gogovega/32/71313_2.png) [@GogoVega](https://discourse.nodered.org/u/GogoVega)\
**Post date:** [27 March 2023 12:17 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985/2 "2023-03-27T12:17:22Z")

</div>

Hi,  
I don't use this node but you can try this [one](https://flows.nodered.org/node/@caitken-com/node-red-contrib-json2mysql), you configure your query directly in the payload as an object.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [27 March 2023 21:50 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985/3 "2023-03-27T21:50:32Z")

</div>

What is the "query mode" drop-down set to?

---

<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:** [26 May 2023 21:51 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985/4 "2023-05-26T21:51:05Z")

</div>

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