689 results found
-
Detect the database compatibility version
When using SQL server 2016 with a database that has it's compatibility level set to 2012, I'm still being offered auto complete options for 2016 features. e.g. string_split
SQL Prompt needs to detect the database compatibility level and adjust it's intellisense accordingly.
3 votes -
Outline for scripts
It would be very helpful if there was an outline for the script being edited. Say, a script has many "CREATE PROC"s. We could have a tree or a list or a drop-down, to view a list of CREATE PROCs and click to scroll to the section.
If a tree style is selected, this could be expanded into seconds inside each PROCs.
3 votes -
Bookmarks
Bookmarks is a feature of SSMS. But all my bookmarks are destroyed once the code is formatted. So, as SSMS' feature is not so good as I want I do suggest to implement this feature by RedGate.
3 votes -
End column guide lines
I think SSMSBoost has this feature: being able to add configurable guide lines to limit the query writing space to a specified number of characters/columns. This is very handy as I always want to keep my code narrow, within the 80-char limit. Currently, I have to install SSMSBoost for it... Could this please be added to SQL Prompt? This is probably a quick feature to implement and would be tremendously useful. Thanks.
3 votes -
prevent Prompt SQL from destroying bookmarks
If format SQL makes chnages - it destroy saved marks
This occurs even when line bookmarked line hasnt (visibly) changed
Very frushtrating3 votes -
don't do auto completion when renaming
When renaming a table alias, or a variable, sometimes you want to rename it to something and SQL Prompt will intercept the return key (to accept the rename) and "auto correct" it - for example, this morning I wanted to change a table alias to "l" and it auto corrected this to "LEFT", so I had to change it back and press enter again.
It's not a big thing, just it happens quite a lot and can be aggravating.
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 -
Add IntelliSense/AutoComplete Support for ALTER ROLE...ADD/DROP MEMBER Statement
I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.
It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember…
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
- Don't see your idea?