Patch: Multiple result set support

[tbk303]

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.

https://gist.github.com/759814

[neurolabs]

Submitted:

deepcored ( deepcored ) - 2010-09-09 06:45:37 UTC