Hi Everyone,
I am using HenPlus with MS SQL database and need to get multiple result sets with a single SQL query at times
It is fairly easy to fix, just add a loop in the SQLCommand class.
As a result of that the following things started to work correctly:
* sp_help MS SQL function shows all information about tables
* Stored procs would return all results now
* Multiline queries like:
SELECT 1
SELECT 'asdf'
SELECT CURRENT_TIMESTAMP
/
return multiple result sets.
Kind regards,
Evgeny.
multiple result sets patch