Node-Red output return from MS SQL Server stored procedure

output parameters will be set in the msg.payload when you select the output type as "driver output"


Why, you might ask?

Well, mssql-plus can do many more things than the old MSSQL node but in order to be an in-place replacement, certain modes and compatibilities needed to be catered for.

In Original Output mode, you simply get "the data". But in order to get access to row counts, output parameters etc, messages, error codes, etc, etc, I needed a way to adjust what the node outputs. This was achieved by permitting either the Original (data only) OR the full driver (NODE-MSSQL) output.