Multiple select statements stream

[huytool157]

Say I want to query this sql query that contains multiple select statements using stream

select * from users; select * from organizations

Since we're using stream, each row got returned one by one. How do we know if row X is a result from the first or second select statement?

Expected behaviour:

Actual behaviour:

Configuration:

// paste relevant config here

Software versions

• NodeJS: 16
• node-mssql: 7.2.1
• SQL Server:

[dhensby]

This isn't really an ideal use case for streams; you should run two separate streams.

However, the request object will emit a recordset event with the columns as the argument every time it encounters a new recordset (ie: query).