140 results found
-
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 -
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 -
"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 -
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 -
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 -
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 -
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 -
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 -
9 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 -
AutoComplete table joins
Have the ability to train intellisense when joining tables to learn which tables join together.
so that in the future you can just type:
"select * from employees e
left join "and intellisense gives a drop down list of related tables, which when selected writes out the table name AND join columns.
i.e.:
"select * from employees e
left join "
and intellisense suggests: "manager m on m.managerID = e.managerID"4 votes -
column lookups in MERGE statements, like in INSERT statements. Click on a column name to find the corresponding value in the VALUES area.
column lookups in MERGE statements, like in INSERT statements. Click on a column name to find the corresponding value in the VALUES area.
3 votes -
Intellisense for Synapse
We have started using serverless SQL Pool in Synapse, on top of a data lake.
In SSMS it behaves mostly as a "regular" SQL Server, however intellisense does not work at all with SQL Complete.
Please implement intelllisense for Synapse.10 votes -
Choose Default Date For Insert/Update Statements
When auto-expanding an insert or update statement by pressing the tab key, the column list provides default values for the columns. With DateTime and DateTime2 in particular, it would be helpful to configure if you want to use the UTC datetime or the current timezone. Our company exclusively stores datetimes in UTC, so to have this default this way would be extremely helpful!
CREATE TABLE #tmp (ID INT, CreatedDateUtc DATETIME2, Name NVARCHAR(50))
INSERT INTO #tmp (ID, CreatedDateUtc, Name)
VALUES (0, SYSDATETIME(), N''); -- allow this to populate as SYSUTCDATETIME() or GETUTCDATE(), depending on DATETIME2 vs DATETIME1 vote
- Don't see your idea?