715 results found
-
Show all index definition details in table script popup
The script preview in the table popup window, doesn't show all the options for create index and primary keys; for example, fill factor is reported, but if a primary key is defined with the OPTIMIZEFORSEQUENTIAL_KEY = ON option, that is not stated.
2 votes -
disable notifications
The pop up that you get when it's slow to gather the cache just clutters up the screen or is a pain to dismiss. I usually just pin it to the side and at the bottom of the object explorer so it sorta disappears forever. But it would be nice to have an option to not even get an alert.
2 votes -
SQL Prompt has no separate configuration for aligning CTE names or OVER()
I would like to be able to control how CTE names and OVER() are aligned. Right now CTE names seem to be part of the general list configuration, but in my case the CTE names are indented. And the OVER() parentheses and content isn't aligned how I set up my parentheses settings (see attached screenshots)
2 votes -
SQL Prompt parentheses alignment for (NOT) IN/(NOT) EXISTS
Parentheses alignment not working as expected for [NOT] IN/[NOT] EXISTS, should be aligned with current statement but the parentheses are indented (please see screenshot attached)
(SQL Prompt 11.3.6)
2 votes -
Intercept F5 and warn if nothing selected
When I hit F5 in an SSMS window where I'm trying to DELETE without a WHERE clause, SQL Prompt intercepts this and gives an Execution Warning. That's great. Is there a way to do a similar warning if hitting F5 with nothing selected, which executes everything in the script file?
In my opinion, that is VERY dangerous because I jump back and forth between SSMS and Visual Studio, where F5 just runs a program. I rarely would want the F5 to execute everything.
Of course, it would need to be an option that could be turned off via “Don't show…2 votes -
Search for column in result
I would LOVE! the ability to have a search window with my results from a query, where I type in any part of a column name and it lists all columns containing value I typed in.
By default one is positioned on the applicable column in the result (scrolling if necessary in wider result set), but if one clicks on any column matching value then it positions one on that column in the result.2 votes -
SQL History - Recent query list filenames - increase number of characters displayed before truncation
This is a minor inconvenience, but one with multiple potentially easy solutions. When using SQL History, I find that the "Recent queries" filenames become truncated very early due to the large font size and having only a single row of text used for displaying them. There is also a chunk of free space / padding to the right side that seems to be wasted (see orange arrow in my 2nd screenshot).
Given the naming convention that I tend to use with my saved scripts ("date - internal ticket # - brief script description/purpose"), I often only see the date and…
2 votes -
Add Connection color to Object Explorer
Dealing with multiple servers via the connection coloring is great, but looking at the object explorer while you are drilled down into things often has me scrolling to figure out what server I'm really looking at. Could we get a color bar in the object explorer that would simply have the color designated for the server.
It would make it easier to tell what environment I'm looking at.
2 votes -
Add a “Save Results As” Excel option
This is needed because I am required to run SSMS with elevated rights.
My regular Windows login doesn't have access to my database servers, and my elevated account doesn't have access to my MS 365 office suite.
Because of this, the "Open in Excel" feature is not useable.
2 votes -
SQL Search endpoint for Fabric
Make SQL Search work with Fabric
2 votes -
frequently use the ScriptObjectAsAlter shortcut in Visual Studio to modify views and procedures. However, when the script opens, it default
frequently use the ScriptObjectAsAlter shortcut in Visual Studio to modify views and procedures. However, when the script opens, it defaults to ALTER VIEW or ALTER PROC, while our source control requires everything to be saved as CREATE OR ALTER.
Would it be possible to introduce an option in SQL Prompt to default these scripts to CREATE OR ALTER instead of just ALTER? This would streamline the process and reduce manual edits before committing changes.
2 votes -
Generate script for Table Types
When hovering over a Table Type the pop-up window only shows tabs for Summary and Dependencies. Add a Script tab for consistent functionality when compared to other types of object such as Stored Procedures, Tables, Views, Functions etc.
2 votes -
Option to display values within IN statements without spaces between them
Another white space removal feature to suggest.
The ability to format all IN statements as:
empType IN ('a','b','c','d')Rather than the default:
empType IN ('a', 'b', 'c', 'd')I have done some exploring in the formatting styles and scouring the forums here and this feature doesn't seem to be available.
2 votes -
Place empty lines between BEGIN/END and their contents
The Whitespace > "Empty lines between statements" option doesn't appear to consider BEGIN/END as separate statements from the code between them, resulting in formatting like:
WHILE @@ROWCOUNT > 20
BEGIN
IF @BusinessEntityID > 0
DELETE FROM HumanResources.Employee_Temporal
WHERE BusinessEntityID = @BusinessEntityID;
ELSE
BREAK;IF @OldId < 2000
RETURN @OldId;
END;Please modify the behavior or provide another option such that the following result can be achieved:
WHILE @@ROWCOUNT > 20
BEGINIF @BusinessEntityID > 0
DELETE FROM HumanResources.Employee_Temporal
WHERE BusinessEntityID = @BusinessEntityID;
ELSE
BREAK;IF @OldId < 2000
RETURN @OldId;END;
2 votes -
One feature idea that I think would be great for many customers. Often I have a pasted column of data from Excel that i need to run a macro
One feature idea that I think would be great for many customers. Often I have a pasted column of data from Excel that i need to run a macro on in Notepad++ to add single quotes and commas. So that I can paste the string into a SQL “in ( ) " clause.
It would be amazing if SQL Prompt had an option to convert that clipboard text right in SSMS. I think lots of people would find that a timesaver.
2 votes -
Option to Change != to <>
Although used quite often, != is not ANSI compliant for NOT EQUAL. Have an option in SQL PROMPT Code Formatting to automatically replace != with the ANSI compliant <>.
2 votes -
Aliases for synonyms
When using a synonym, the alias name generated is based on the synonym orginal table, not in the synonym name.
So, if I have a synonym named sch1.ShortTableName that maps on AnotherDatabase.sch2.TableWithLongAndComplexName
If I write
SELECT * FROM sch1.ShortTableName
It ends being
SELECT * FROM sch1.ShortTableName AS twlacn
It would be good that in case of synonyms, the alias name was based on the synonym name, not on the source object name.
Or to keep backwards compatibilty, to have a setting that lets us choos either to follow the synonym name or the source object name.
2 votes -
Allign all euals of a set part in an updatestatement
Allign all equals of a set part in an update statement
2 votes -
Turn off SQL Prompt+ AI
Please can there be an option to turn off SQL Prompt+ AI. It is a pointless feature that I have found no benefit from. It locks up and crashes SSMS. It also it an extremely intrusive feature constantly displaying the icon next to the cursor
2 votes -
SQL Rule/Issue/Error Search
Like SQL Search, but SQL Error/Issue/Rule violation.
This would list all issues that exist in a database.
Example: "Non-scalar subquery in place of a scalar value"Because these issues can cause major slowdown in queries, and it would be great to have a way to search a whole database to find these rather than having to open all the views, procedures, and functions to find all these things.
2 votes
- Don't see your idea?