Menu
I'm wondering if it's possible to setup SQL Server to have multiple rows of tabs for files / queries.
I have a lot of queries I want to switch between, and could move them to different horizontal groups, but I think two rows would be much easier to navigate than that pin on the left that drops down the big list of open queries.
Visual Studio kind of supports this if you pin enough code windows to fill up the top bar.
Is there something similar in SQL Server?
Edit:
I'm trying to achieve something like this (screenshot from Visual Studio)
While SQL Server is more like this
378
You can get a list of open tabs (Active Files) using the Ctrl-Tab shortcut. Continue pressing Tab to cycle through the list and release when the desired tab is highlighted. Or just mouse click on the required tab while keeping Ctrl depressed.
You can concatenate rows into single string using COALESCE method. This COALESCE method can be used in SQL Server version 2008 and higher. All you have to do is, declare a varchar variable and inside the coalesce, concat the variable with comma and the column, then assign the COALESCE to the variable.
You can use the SQL tab to read data from or write data to a database. It contains the Generated, User-defined, Before, After, Generated DDL, and User-defined DDL tabs, depending on the particular stage you are using. Use these tabs to display the stage-generated SQL statement and the SQL statement that you can enter.
It's now available in current ssms version. From menu => Tools => options:
131
By default SSMS includes Database name, File name, Login name and server name in each query tab title. So that we can see only 3 or 4 tabs at a time.
There is a work around for this,
go to Tools > Options > Text Editor > Editor Tab and Status Bar and change all of the "Tab Text" group options to false except for the file name.
This will reduce the tab name, so that SSMS will show more tabs at a time
34
I know of at least one plugin that will do this in SSMS (and Visual Studio). Because, yeah, it would be nice.
Tabs Studio - document tabs manager for Visual Studio IDE.
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
