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

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

24 results found

  1. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. It would be nice if there was a way to import and export all SQL Prompt options like how you can import and export format styles.

    39 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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).

  6. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. I would like an additional option for the Inserted code > Qualification tab:

    Qualify column names with table aliases only.

    Most times I want to assign a table alias and use it when adding columns, however if I forget to assign a table alias or remove it, I don't want a fully qualified table name when using the Qualify column names with table name option.

    I would like the option to qualify with both table names and table aliases or just table aliases and NOT table names.

    16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  11. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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.

  12. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. I frequently need to work on longer procedure or scripts, and the longer the script gets Sql Prompt gets more and more bogged down, to the point I just turn it off. It would be nice to be able to toggle it from the toolbar rather than open the options to un-check 'Use SQL Prompt'

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. It would be great if the Options-forms was resizable (and the formsize was stored when closing the form).

    The 'Sample SQL' textbox would then be larger so all SQL code is visible with the formatting options that are chosen.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Some users report that having to go into options to disable prompt temporarily is long winded. Can there be a quicker way (perhaps a keyboard shortcut or direct menu option)?

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Aaron Law responded

    I’m going to close this idea to return your votes since I think it was completed a while back (you can disable suggestions with Ctrl+Shift+P or from the Prompt menu). If I’ve misunderstood then feel free to create another idea with more specifics.

  16. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Aaron Law responded

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

  19. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1
  • Don't see your idea?