suggestion: be able to handle multiple SELECT queries

bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases

MIT License

32 stars 18 forks source link

Closed jonferreira closed 4 years ago

jonferreira commented 4 years ago

Hi,

Just a quick suggestion I'd love to see it being implemented.

Add the ability to handle multiple SELECT queries, e.g.

msg.payload =

SELECT * FROM Customers;
SELECT * FROM CustomersDetails;

In Studio Management or Navicat this will execute 2 SELECT queries and return each one.

Would be great to have a similar behaviour here, maybe having the node return these as an array:

msg.payload = [ [query 1 results array],[query 2 results array] ]

Steve-Mcl commented 4 years ago

This node already supports multiple queries.