Microsoft SQL Server Management Studio has a great feature: when executing multiple queries, it splits the results area into as many horizontal panes. For example, if executing three SELECTs, instead of appearing in tabs, it would divide the results pane into three panes, allowing simultaneous viewing of the results. See attached screenshot for an example.
This allows easier comparisons, and is very convenient for example when exploring tables related by foreign keys.
As far as I know, SQuirreL SQL does not have such a feature, right? It would be awesome to see it added.
There is a "Show results in new window", which detaches the tab and makes it a floating window you can freely resize and move around on the screen, which I understand is even more flexible than what you requested.
This magic button is next to the "X" that closes a tab and looks like a folder.
Last edit: sfst 2014-05-16
Thanks. That is indeed more flexible, but arguably more complicated than MSSQL's "split panes results" feature, because with MSSQL I can just run five queries and immediately have the available space conveniently split into five panes, readily available for comparisons without any window manipulation.
Achieving the same with the SquirrelSQL feature you are mentioning would require five clicks, plus five windows moving + resizing.
What is MSSQL SMS doing if you execute 15 select statements at once?
Scrollbars ensue:
Is there an update to display multiple results in split pane, rather than multiple tabs? Please advise.
Thanks in advance.
Sorry, no there isn't.
But as always everybody is invited to implement it and to send me patches or merge requests.