272 results found
-
Format Document button enhancement, to give the ability to select Style
It would be nice if the "Format Document" / "Format Selection" toolbar buttons in SSMS had a drop-down arrow next to them (like the "Other Windows" button in the Standard Toolbar). When pressing that arrow, all available Formatting Styles would appear in order for the user to select the formatting style to use. If the button was directly pressed, the default Style would be used.
If that is difficult, it would be nice to have a separate combobox containing all Styles and use that to perform the formatting when the button is pressed.
3 votes -
Alter Format of Generate Script > Insert #tmpTable
With in the feature "Generate Script > Insert #tmpTable", it renders the DROP TABLE after the CREATE TABLE and SELECT. In troubleshooting and R&D, however, there is value in having the temp table be retained. 90% of the time, I transform the DROP TABLE in to DROP TABLE IF EXISTS and move it to just before the CREATE TABLE.
I would like the option to either customize the rendering to fit my needs, or the option to select this alternate style of rendering in Options.
3 votes -
Option to remove the new Clear button from Query History
The new Clear button in Query History seems, in context, to mean clearing the search or filters applied to searching the history. However, it clears the history - deleting everything. Please either let me turn it off or, even better, just move that to the Options / Settings area. I lost so much history because I wasn't paying close enough attention.
3 votes -
Extend the 'Tabs Color' functionality to 'Edit top x rows' SSMS tab.
Extend the 'Tabs Color' functionality to 'Edit top x rows' SSMS tab.
1 vote -
"Are you sure?" for specific environments
The tab coloring is great, but sometimes you need another layer of protection. It would be fantastic if certain environments could be designated as "protected" or something like that, and if you execute a script that in environment that does anything other than a SELECT (INSERT, UPDATE, DELETE, TRUNCATE, ALTER, etc.), a good old-fashioned "You are running this in "<environment name>. Are you sure?" dialog pops up and you have to click YES in order to actually execute the script.
3 votes -
Fields in Alpha Order
Add an option to expand SELECT * to allow the expansion of the fields to be ordered in the order they currently are or to have the fields listed in Alphabetical order. I work with some tables that have many, many fields and they aren't in a very logical sequence, so I end up searching for the field I want. If I could expand the SELECT * and have the fields be in alphabetical order that would help a lot.
Of course I can use Find to find the field I want, or create a snippet that lists these table…
1 vote -
Add an option to Execute Current Batch
Add an option to Execute Current Batch, similar to Execute Current Statement, but highlight and run everything between the current batch separators.
It's a feature I've seen that RedGate SQLPrompt provides and it would be useful to have the ability to run everything within the current batch without having to highlight it all first and then running the selected text.3 votes -
lowercase option for snippets
Add an option to choose the case for snippets - uppercase / lowercase / sentence case. This is already a feature for keywords.
3 votes -
Add "Search" button to execution history and disable auto-search option.
When searching in execution history, the search value is used pretty quickly after you stop typing. This means that you have to wait for the search to finish even if you weren't done typing the search string. It also means that if you have a typo, you have to wait for the search to finish before you can correct it. I keep a long history of executed SQL, so each search takes a while to run.
In my opinion, it would be better to have a dedicated "Search" button so that you could submit your search string when you're finished…
2 votes -
editing single instance Stored Procedures
An option to only allow editing a single instance of a Stored Procedure, Function, etc. (and perhaps the name in the tab or top of file). Or at least a warning if this procedure is already open in another tab.
1 vote -
F12
По F12 объект ищется в текущей базе. Но поиск не срабатывает и падает с ошибкой если:
- В базе стоит фильтр, и обьект не может быть найден при текущем фильтре.
- Если в окне студии открыт например код процедуры - и он трактуется как некорректный, например из за того что процедура уже есть в базе, а открытый скрипт начинается с CREATE PROCEDURE... То по F12 также выпадет ошибка. Нужно вручную заменить CREATE например на ALTER, только в этом случае поиск по F12 опять сработает.
Более того, вцелом неудобно сначала по F12 делать поиск, а потом дополнительно на найденом объекте по выпадающему меню…
1 vote -
Refactoring suggestions
I really love the refactoring features, but came across 2 things that might be addressed.
when renaming procedure variable and the same variable name is used in other SP that is called using explicit variable assignment, e.g.
EXEC dbo.otherSp @variable = @variable,
the other SP variable gets renamed as well
(e.g. rename
@variable to @newName creates
EXEC dbo.otherSp @newName = @newName
instead of
EXEC dbo.otherSp @variable = @newName)
when variable is part of an EXEC command and parameter contains assignment operator, only the variable following an assignment operator should be renamedwhen leaving table alias as it is and changing…
1 vote -
Create SQL Complete Extension for Visual Studio Code
Create SQL Complete Extension for Visual Studio Code
More and more I find our developer teams using Visual Studio Code as single IDE for all development and scripting. While the SSMS and Visual Studio extensions are great, most of our developers are not using those tools as much and find it cumbersome to open up the supported IDE's to get SQL Complete's benefits.3 votes -
Auto scroll in Messages tab in "Results in Grid" Mode
Please add Auto scroll in Messages tab in "Results in Grid" Mode
3 votes -
Color brackets.
Please add the ability to color brackets. Just like it happens in Excel, for example, when you write a function. The opening and closing brackets are marked in one color.
1 vote -
Standard color for inactive tabs
With the tab coloring feature, it can be difficult to tell which tab is the currently active tab just by looking at them. Some of the colors of the disabled tabs come through as slightly different than when they are active, but look like they might be active because they are close to other colors.
I would suggest either making all inactive tabs gray, or to introduce some other type of visual queue to help easily distinguish active from inactive tabs.
I can't upload a screenshot here but I do have one as an example.
0 votes -
Document sessions
Enhanced Documents Sessions
The main issue I have with SQL Management studio is managing all the tabs and code. One great feature would be the ability to automatically group all sessions by the active database. A modern approach would be to have "grouping" tabs, where you can place code, or a tree approach with subtrees.
The single biggest issue I have is editing stored procedures/functions. If you multiple tabs with the same proc and edit one, then open the other tab and edit by mistake, it is a disaster. Being able to label a session with the actual stored proc…
1 vote -
Integrate SSMS with CoPilot
We have already GitHub CoPilot for Visual Studio.
Integrate please it also with SSMS. Or directly ChatGPT2 votes -
Line break after SELECT only if a DISTINCT / TOP clause is used
Title says it all... Give me the option to insert a line break after SELECT only if a DISTINCT / TOP clause is used.
3 votes -
column alias
I would like an option for column aliases. I would like to choose between = or AS for the "Alias sign".
The formatting should be done based on this "alias sign" and also be aligned by the alias sign.I prefer the = sign , but formatting doesn't seem to accept that as an alias now.
Example before formatting:
SELECT colA as [Column A], columnB as [ColumnLonger B]
FROM Table_1 tFormatting when "=" is used as "Alias sign";
SELECT [Column A] = t.colA
,[ColumnLonger B] = t.columnB
FROM Table_1 tFormatting when "AS" is used as "Alias sign":
SELECT…
6 votes
- Don't see your idea?