Node-red-contrib-mssql-plus Execute Procedure

General
1

Hi all!

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

image
image1374×674 23.1 KB

gives me msg.payload: undefined

This is the working SQL studio code:

USE [xxx]
GO

DECLARE	@return_value int

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

SELECT	'Return Value' = @return_value

GO
2

Hi,
I don't use this node but you can try this one, you configure your query directly in the payload as an object.

3

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

4

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