98 results found
-
Additional syntax coloring - override SSMS
So I'm not sure if this is something that SQL Prompt has the ability to do or not as far as access to SSMS.
When you customize syntax coloring in SSMS, it sees variables, tables, column names, etc all as the same thing...."Identifiers"....I would love it if I were able to specify a different coloring scheme for variables, separate from the rest of the identifiers.
2 votes -
Colors Option For Different Databases
Colors Option For Different Databases
2 votes -
Include BEGIN TRANSACTION with "Execute Current Statement" (Shift-F5)
While using Shift-F5 to execute the current statement, any BEGIN TRANSACTIONS above your UPDATE are ignored, running it not in a transaction.
I shouldn't use Shift-F5 probably, but it's becoming a habit and could be very expensive when forgetting to highlight-execute.2 votes -
SSMS - object list - filter from clipboard
In the right-click menu of the "Tables" branch in SSMS, create an extra item that would retrieve string from system clipboard and apply it as an object name filter (using the SSMS built-in [Filter] => [Filter settings] => [Name] => [Contains] feature).
This would allow for instant filtering, saving lot of time.
2 votes -
Make Ctrl-Y repeat last action
I use actions (from the ctrl menu) a lot. It would be extremely handy if I could re-do last action on the currently selected text by simply hitting Ctrl-Y (rather than hitting Ctrl and selecting it from the list of actions again and again).
2 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.
1 vote -
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…
1 vote -
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.
1 vote -
make update notification window resizable or autosize with Windows zoom
I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)
With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.
However, for minor upgrades, I often skip the upgrade process…
1 vote -
Set preferences for automatically numbering new queries
New queries, as users know, have an automatic naming and numbering system:
SQLQuery1.sql, SQLQuery2.sql, SQLQuery3.sql, etc.It would be helpful sometimes if the queries could have leading zeros or maybe even a different lead-in like the name of the solution. For example, SQLSolutionABC might have the default tab names:
SQLSolutionABC001.sql, SQLSolutionABC002.sql, SQLSolutionABC003.sql, etc.
1 vote -
Add a warning for using a self-join in a delete or update statement
Add a checkbox to the warnings settings, for if a self-join is detected when doing an UPDATE or DELETE.
1 vote -
Aggregate Min/Max for Date/Time
Show aggregates Min and Max for Date/Time columns in result grids.
1 vote -
Automatic Log In after Update
After every update I have to Log On to get SQL Prompt working. Can´t the update do this or just do not log me off?
1 vote -
Make Import / Export of options more flexible (xml file format or enable partial export of sections)
I would like to be able to export (+import) only specific portions of the options.
So that I - for instance - may only distribute my aliases or my coding style options to the team; not everything. The current binary format for the export file only allows for an all-or-nothing approach.
So please
(A) Make the export file a xml-format, so we can filter it ourselves
or
(B) Add a dialog to allow us to mark the sections to be included into the export file via checkboxesThis would also likely solve other feature-requests:
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/46784125-export-snippets-to-text-file
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/40966285-sql-prompt-setting-sharing
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/39174019-import-and-export-aliases1 vote -
Add menu item that collapses all servers in Object Explorer
After I connect to multiple servers at one time using the Registered Servers window, the connected servers appear expanded in the Object Explorer window, and then I manually collapse each one. I also find myself scrolling up and down in the Object Explorer window to manually collapse servers I've expanded throughout the day. A menu item to collapse all of the connected servers in the Object Explorer window would be a feature I would use quite often.
1 vote -
AI to help detect databases/schemas most often used?
I got a suggestion from SQL Prompt for "Slow cached time detected".The link (seen in the screenshot) was this one:
https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory
So from what I understand, I need to manually go through all databases and schemas and select the ones I think are used to the most in order to only load suggestions for them, in order to improve performance?
While I generally like SQL Prompt, the first word that came to mind was that this pretty much sucked, but let's just say it's less that optimal I think. Given that we’re in the ”AI age”, I was hoping that…
1 vote -
Disable update and new notifications
It would be great if you would introduce a new setting where we can turn of update- and other notifications (like "SQL 2008R2 not supported") warnings.
1 vote -
coalesce
I often need to wrap a column in a coalesce with 0.
It would be swell if there was a feature where I could select a column, then either right click or Keyboard shortcut to have it wrapped in coalesce.
E.g. select the word
personCount
and have it be replaced with
coalesce(personCount,0) as personCount1 vote -
Include snippets in command palette searches
It would be useful to have snippets included when searching in the command palette. Selecting snippet would open snippet editor with focus on the selected snippet.
1 vote -
Version Specific Snippets Script Blocks
I would like to be able to specify different script blocks inside a snippet that would work differently based upon the sql server version of the server I am connected to.
Or.... optionally have a version indicator on the snippet to perform the same thing. Then if two snippets share the same name it would apply the correct one based upon version.
EX:
…:if $version_major$ >= 13 CREATE OR ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN $CURSOR$SELECT @param1 END GO :else IF OBJECT_ID('[$dbo$].[$proc_name$]', 'P') IS NULL BEGIN EXEC('CREATE PROCEDURE [$dbo$].[$proc_name$] AS BEGIN SELECT 1; END;') END GO ALTER PROCEDURE [$dbo$].[$proc_name$]1 vote
- Don't see your idea?