Vscode-mssql: [Feature Request] Results pane opening behavior

Created on 9 Apr 2020  路  8Comments  路  Source: microsoft/vscode-mssql

When you execute a query, the results window opens to the right of the SQL editor (by default). This is controlled by the "Open Side By Side" setting under Workbench > Editor Management. This is a global setting. It controls how all side-by-side editors are opened. I find the default behavior of opening to the right to be preferable for most file types, but for SQL, the results are more readable if they open down, instead of right.

It would be nice to have a mssql-vscode specific setting to control the default placement of the results window.

Steps to Reproduce:

  1. Open SQL text in the editor.
  2. Execute it.
  3. Results appear to the right.
enhancement upstream

Most helpful comment

Currently a show stopper for me.
Every tools I know which execute SQL queries display theresult at the bottom !

Best, the result should be displayed in the log window, not in a new tab.

All 8 comments

Currently a show stopper for me.
Every tools I know which execute SQL queries display theresult at the bottom !

Best, the result should be displayed in the log window, not in a new tab.

15967212340167110399535977800971
Unless I am misunderstanding you guys, you can do this. View > Editor Layout > Split Down. I agree... I run one monitor vertically so opening to the side would be a no-go for me as well. Once I saved a workspace with this option it always opens like this 100%, I haven't had to mess with it since I installed mssql.

I don't think the OP wants every pane to split down, just the MSSQL one.

Horizonal split isn't too bad for low column count queries but here's an example of 16 columns , VSCode (MSSQL Extension) vs SSMS

image

image

I don't the OP wants every pane to split down, just the MSSQL one.

Horizonal split isn't too bad for low column count queries but here's an example of 16 columns , VSCode (MSSQL Extension) vs SSMS

image

image

All of my results do show up vertically just like SSMS. I updated my comment with a picture of what mine looks like. I think VS Code can already do what they are asking for (unless I'm not getting what they are asking).

@systematical that's fine for when you are using the MSSQL extension. But we don't want this to be the default behaviour for the whole IDE

Alright that makes sense, and I agree with you guys in that case. I do also use it for Python and it puts the output at the bottom as well so I guess I haven't seen it put results anywhere other than vertically and on the bottom after I changed that setting.

I looked into this issue and looks like it's upstream. VSCode doesn't give extensions the ability to split the editor in it's own way, and we need to follow the VSCode setting for it.

Any update on this?

Was this page helpful?
0 / 5 - 0 ratings