Skip to content

SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums or our support portal.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

25 results found

  1. Turn off notifications such as "Slow cached time detected".

    Have the ability to turn off notifications such as "Slow cached time detected". I see it every time I connect to a database - and I work with every element in the db's so I want it all to be cached. But I do not want to see this notification every single time.

    34 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    16 comments  ·  User interface  ·  Admin →

  2. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  3. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  4. Disable auto update check on startup

    It would be nice if we can turn off the auto update check for a new version on start-up. This check is happening in the Visual Studio database project and in SSMS. I'd like to disable it. Thanks!

    36 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    32 comments  ·  User interface  ·  Admin →
    completed  ·  AdminTim Dalton (Product Manager, Redgate) responded

    In Prompt 10.0.11 we added a new option to the help menu called ‘update notification frequency’. This will allow you to reduce the frequency of updates all the way down to major versions only (one update a year).

  5. Duplicate Tab

    One of the common UI interaction features in browsers like Chrome and IE is Duplicate Tab feature.

    Ususally the reason you might want to do this, could be because you want to keep an UNALTERED TAB and do SOMETHING DIFFERENT with another page...

    In SSMS this could be a great feature. Example of use please (- I hear you ask)? You could be trying to change script and test the effect of that change vs the original!

    MUCH MUCH Further down the line, you could extend this feature, to highlight the differences between tabs, a bit similar to file compare…

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  6. Option to remove gutter menu

    Please provide a way to turn off the gutter icon. I do not use it but what DOES happen is that I constantly activate it when I'm selecting and moving around in my sql. It's annoying - extremely.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Admin →
    completed  ·  Aaron Law responded

    Hi Nick,

    This should already be possible in the latest version of SQL Prompt (7.2.4), you can right click on the icon in the gutter and select “Disable actions list”. Alternatively there’s a check box in the SQL Prompt options on the behavior page for “Show actions list for selected test” and unchecking this should also disable the feature. If you have any problems with it still appearing after you’ve disabled it just let me know.

    Thanks,
    Aaron.

  7. Sum selected columns

    It would be nice to have some capabilities that exist in Excel 2013. Specifically the feature when you can highlight a column and then at the bottom of the application it gives you some quick statistics for the column. So if I had a column of numbers, and I highlighted the column in the results pane it would give me the Average of the numbers in that column and the sum of the numbers in the column. If the column was text you could see the count of distinct values in that column. This just gives quick access to statistical…

    35 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    13 comments  ·  User interface  ·  Admin →
    completed  ·  AdminTim Dalton (Product Manager, Redgate) responded

    The ability to show the aggregate values of a selection of cells in the result grid was added as part of SQL Prompt 10.15 https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-15-release-notes.

  8. Highlight variables having the same name...

    This feature would be great... http://stackoverflow.com/questions/21899826/sql-server-management-studio-highlight-variables

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  9. Generate Scripts Based on the Result Grid

    Just like in Toad and SSMSBoost, there's a facility to create a script such as INSERT based from the given result grid. This would be handy in generating test data or re-populating tables

    37 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  User interface  ·  Admin →

  10. Copy column from grid results as comma separated list

    Oftentimes when I am writing queries, the results from one column of one query are quickly needed in my next one in an IN clause. I highlight the column of values from the results grid and paste into the query window, and then have to append commas (and for neatness, I delete the line breaks). I would be nice to have an added option the context-menu of the results grid to add a copy as comma separated list (in addition to the current copy and copy with headers options).

    16 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  11. Shortcut for Switching Styles

    Can you add "choose style" or "switch style" to the commands section, as a drop down, so that it can be added to the SQL PROMPT toolbar? Or possibly as a hot key menu option?

    I switch styles often. There's the style I like to work in, a style suited for debugging, and the style that management likes the code to be posted with (in TFS.) Being able to switch between them is very helpful. but, going to SQL Prompt --> Options --> Styles --> Selecting Style "with the mouse" is time consuming.

    Thanks for your consideration!

    Lawrence Barnes

    10 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  User interface  ·  Admin →
    completed  ·  Thomas Walsh responded

    We’ve released support for quick switching of active styles in version 8 of SQL Prompt. You can right click in the editor window, select `Active Style` and then choose the style you want to switch to.

    You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

    If you are still keen to have this functionality available via a hotkey, please let us know by opening a new suggestion.

    Kind regards,

    The Prompt Team

  12. Remove Red Gate toolbar

    This is an old problem that just won't go away.

    The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.

    Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.

    Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).

    6 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  User interface  ·  Admin →

  13. Insert Statement Highlighting with Split-Screen

    Excellent work by the team in SQL Prompt 6.4 implementing the "Insert Statement Highlighting Column and Value" feature.

    http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/4223150-insert-statement-highlighting-column-and-value

    It would be great if this could be tweaked to work with split-screen editing. For example, if you have a REAAALLLY wide table, you might want to have your editing cursor in the bottom pane of SSMS but be looking at the top pane.

    To clarify, I am talking about allowing the highlighting to work in both the top and bottom panes if you enable Window... Split (or drag the thing down at the top of the scroll bar).

    This new…

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Admin →

  14. sort

    It would be nice to have sortable columns in the table popup. This way we can see them in ordinal order (as it exists now), or order them alphabetically (or even by data type). Hopefully not much harder than changing a grid column property.
    This would make it much easier for our Oracle folks to accept using SSMS, as it seems all Oracle tools do this by default. It would also shut them up. :) :)

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  15. Allow Ctrl - > to escape from SQL Prompt so we can move to the next word.

    Ctrl - > (right or left arrow key) is the default for move to next word in the editor. In order to escape SQL prompt you can use the left or right arrow, esc etc, but why not include Ctr right arrow or Ctr left arrow so we don't have to type the extra characters. Makes coding with SQL prompt burdensome. Still use it and thanks!

    8 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Admin →
    completed  ·  Aaron Law responded

    SQL Prompt 6.2.0.366 doesn’t swallow the Ctrl+Left and Ctrl+Right if the column picker is disabled.

  16. Insert Statement Highlighting Column and Value

    Assume that I have an INSERT statement such as:
    INSERT INTO dbo.MyTable (Column1, Column2, Column3)
    VALUES ('Apple','Orange','Grape');

    If the mouse pointer is in the word 'Apple', the text Column1 should be highlighted in some way. This will help the user clearly see the alignment of which field they are in. If I move my cursor over to 'Orange', the text Column2 should then be highlighted. This is a very simple example, but sometimes I deal with queries with dozens of columns and it's a chore just to find which value in the bottom of the query corresponds to which value…

    21 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  User interface  ·  Admin →

  17. Execute current statement/block

    It would be greate if you could make an option to Execute current statement/block/all staments from top to current stament (current=where the cursor located) when clicking Ctrl + Alt + F5/Ctrl + Shift + F5/Alt + Shift + F5.
    So, if the the cursor located in a the middle of long script, and I'm clicking Ctrl + Alt + F5 it will execute the currnt statment like if I would have select the current statement and click F5.
    Same for Ctrl + Shift + F5 and Current block and for Alt + Shift + F5 and all staments from top…

    43 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    9 comments  ·  User interface  ·  Admin →

  18. highlight similar words

    Double clicking a word hightlights all instances of that word. This makes it easier to see where the word is used. Good for particularly long scripts.
    Double clicking a table, column, function, view etc. highlights all in your script.

    64 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  User interface  ·  Admin →

  19. Turn Off Schema Collection

    I'd like to enable schema collection when I'm writing code, and disable it when I'm doing adhoc queries. Why: We have 100 identical databases with 1900 tables in each database. When I run a query that pulls data from each database sqlprompt starts collecting schema data from all 100 databases, then it runs out of memory and crashes.

    The "Turn Off Prompting" option does not help.

    example:

    select id,customer from DB1.dbo.orders where date > @d
    union select id,customer from DB2.dbo.orders where date > @d
    ...etc...

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  20. Option to sort column lists by table order as rather than alphabetically

    Have an option to sort the column list as it appears in the table rather than alphabetically. I have a good memory for where the functionality sits in the table, but I don't always remember the name. Columns are often logically placed in the table.

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →
    completed  ·  Aaron Law responded

    SQL Prompt 6.3 will display the columns in their table order rather than alphabetically

← Previous 1
  • Don't see your idea?