155 results found
-
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…
5 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 -
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"3 votes -
9 votes
-
Apply Block Comment to Selection
Provide a keyboard shortcut that applies block comment characters at the beginning and end of a selected text. Allow customization so that you can specify how many space characters or newline characters you want applied after the beginning comment characters/before the end comment characters.
3 votes -
Add Troubleshooting solutions in error tooltips
Example 1:
If you are using a NOT declared variable @var1, @var1 will get underlined and there is a tooltip with the error.
On the tooltip there could be a suggestion: "add declare @var1 int".
Example 2:
If you are executing a procedure and you are missing some mandatory parameters then there could be the solution "add missing parameters" on the tooltip2 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.9 votes -
AS keyword
Include a formatting option to "Always include AS keyword for aliases". The goal would be to change
SELECT
*
FROM
[dbo].[Table1] [T]into
SELECT
*
FROM
[dbo].[Table1] AS [T]Note the AS added to the FROM clause. This option could be global (Misc group?) or could be a separate option for each relevant clause (SELECT for field names, FROM and JOIN for table names, etc.).
1 vote -
rename
It would be very helpful to be able to right click on a tab in SSMS and have the option to rename it.
I currently have "SSMS Tools" installed to be able to accomplish this. Would be great to have the option in SQL Complete and be able to uninstall "SSMS Tools"
3 votes -
NewID() Snippet
I want to create a snippet that will generate a new guid value (the actual value generated from NewId()).
1 vote -
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 -
Copy as SQL values List
Would be great to be able to highlight multiple cells in the Results grid and then select "Copy as SQL values List". This would then create a single line, comma-separated list which could, for example, be pasted into a WHERE in () clause.
Functionality must be able to detect whether you're copying integer or character values etc. If copying character values, SQL Complete should automatically enclose each value with single quotes
10 votes -
Create an option just change casing
In SQL Complete, I would love an option that lets you Format Selection but only changes the casing to what you have specified in your active profile. It would leave all other formatting as is.
3 votes -
Email notification when query completes
I previously used SSMSBoost. There was a feature, Query Post-Execution Handlers, that included Results per Email as an option. This feature leveraged PowerShell as the engine, perhaps because it was a Windows installation, and a "script generator" dialog box that converted selected options and variables into a PowerShell script and email message. I would have added a screen capture of this interface, but this post won't accept attachments. The feature also accepted a threshold so it would only apply to queries that exceed a specified number of seconds. It was nice to be able to set this up for long…
1 vote -
Change Connection on Multiple Tabs
I would like the ability to change the connection on multiple tabs in a single action. Currently, if I am testing in one environment with multiple tabs open, I need to change each connection individually. I would like a way to specify a new connection for multiple tabs.
3 votes
- Don't see your idea?