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

621 results found

  1. User of SQL Prompt for some years now. Tab History was a "killer feature". I often have multiple instances of SSMS open, with a number of ad-hoc queries open not worth saving. When I log back in, for years, WITHOUT FAIL, ALL my queries, from ALL instances would re-open.

    Since "upgrading" to SQL; History, I am lucky to get one or two re-open. Complete pot luck. Even searching for known keywords to get them open again is hit and miss.

    I am losing a lot of productivity due to this downgrade. I have yet to experience any benefit from the…

    12 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

    1 comment  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Tab History NEVER should have been replaced with SQL History, a very poorly received roll-out that angered many paying customers. The fact that Red-gate felt it necessary to re-brand the thing is indication enough that it wasn't simply an update to Tab history but a replacement. That said when you do something like this in a product people are paying for it should be rolled out as something new and not something that replaces an existing beloved feature.

    Perhaps after enough updates SQL history will be usable and thus tab history unnecessary but there's no telling how many updates that…

    15 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

    0 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. The new option would allow intending from alias (in alias = expression notation)

    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

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. At present, when I search (and I hate that the search opens as a new screen), I have to click "advanced search", and select object type of "queries" (I'm really not interested in the query history, I'd rather turn it off but there's no option to do that)

    The one thing that would be most useful thought would be to remember the advanced settings between uses - or maybe allow them to be saved as a search default. This would go some way to address the poor user interface changes that have made the new SQL History much harder to…

    7 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

    2 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. SQL Prompt allows users to set custom directories for various files.

    It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.

    I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.

    The only way to do this now is via REGEDIT.

    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)
  6. I really love the add (quotes and) commas feature in SQL Prompt. Unfortunately we cannot produce a snippet similar to those.

    If you select some text it would be nice to format each line to a certain format.
    Like for example

    E46337E5-ECBC-41D4-A63E-A994E16BD8F7
    669F0B8E-5E1C-47CE-A799-81B47C9BC045
    65D23D56-7EB8-44AE-9158-C3D8B5684357
    AAFE4057-10B9-4AE8-BE76-C22537D29790
    4426C0B6-6216-4BFE-BE54-C1D917B593A5
    7BC5ED9E-E8C3-4618-B625-786F4B931D97
    01A37706-63FA-46E5-99EE-293FF290B34D
    94CAB432-EA1C-4972-8CD6-3C8B9E1A096B
    2C801ADE-995A-4158-9D0A-7DA03911D093
    425BAAC6-6A0B-419C-B393-79B21A628538

    turn into

    ('E46337E5-ECBC-41D4-A63E-A994E16BD8F7'),
    ('669F0B8E-5E1C-47CE-A799-81B47C9BC045'),
    ('65D23D56-7EB8-44AE-9158-C3D8B5684357'),
    ('AAFE4057-10B9-4AE8-BE76-C22537D29790'),
    ('4426C0B6-6216-4BFE-BE54-C1D917B593A5'),
    ('7BC5ED9E-E8C3-4618-B625-786F4B931D97'),
    ('01A37706-63FA-46E5-99EE-293FF290B34D'),
    ('94CAB432-EA1C-4972-8CD6-3C8B9E1A096B'),
    ('2C801ADE-995A-4158-9D0A-7DA03911D093'),
    ('425BAAC6-6A0B-419C-B393-79B21A628538')

    OR even better

    prepend

    SELECT t.x FROM (VALUES

    and append

    ) t(x)

    I often use this format to look up data in the database. I know I can achieve this with Excel and consorts. Or even with…

    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)
  7. Currently users have to install SQL Prompt updates manually and this requires administrator privileges which is not ideal in a workplace setting. I was wondering if this could be changed so that SQL Prompt updates itself without the need for manual install and administrator privileges.

    Thank you in advance for your help.

    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)
  8. SQL history. Recently this has become more indepth with greater search and history detail available. However it has lost some features which I found to be invaluable and which now make SQL history less useful to me.

    Find Starred items doesn't work as well now. It uses the advanced search which does not actually show if items are starred. Please correct that.

    Also there is now no ability to sort items found (in either normal or search view) by name / date etc.

    Can these features be re-implemented please.

    15 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

    under review  ·  3 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. AI suggestions.

    I'm not part of your AI program waiting list. However here what I suggest.

    Do not make the AI part of your program an only cloud-based solution. There are plenty of opensource code models free for commercial use that can be ran locally on a PC. These models can also run under CPU but will up the memory to enable this feature requirements for AI on client side only. It's too dangerous for Redgate to store this information on the cloud even with a solid EULA, and laws are subject to change. Please offload this burden back to…

    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)
  10. SQL Prompt and SSMS do not have the option to create/remove block comments. This is a serious problem.

    We SQL Prompt users would love the option to add/remove block comments in SQL, between the marks /* and */, because they sometimes serve very different purposes.

    Inline comment options (Ctrl + K, Ctrl + C or Ctrl + K, Ctrl + U) are helpful, but they don't always do exactly what we need. Sometimes they can break things. See below.

    /*
    Sometimes we need block comments that cover multiple lines.
    Like this.
    /
    /
    Or comments where each line begins and…

    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

    2 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. SQL History sorts files by modified date ASCENDING. Its needs to be DATE DESCENDING. Need options to sort by name or date, ASC or DESC. Like how TAB HISTORY used to.

    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

    4 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. I prefer opening SSMS with no tabs and use SQL History to navigate tab history. It would be great to have an option to open SQL History on startup and/or if SQL History is docked then redock SQL History on startup

    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)
  13. Add an Enable checkbox in the Style Sheet | Global | Parenthesis settings.

    When SQL Prompt encounters the 'old style' usage of TOP, without parenthesis, automatically enclose the apparent 'what' in parenthesis.

    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

    0 comments  ·  Format SQL  ·  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. With SQL Prompt, and selecting "Copy as IN clause" on a resultset, is it possible to format the result as all one line, like:

    IN (1,2,3,4,5,6)

    instead of what it does currently:

    IN (

    1,

    2,

    3,

    4,

    5,

    6) ?

    Having it all on one line makes a statement easier to read, when there are a lot of items in the list.

    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)
  15. For those of us who have to move between current and older versions of SQL Server, provide a tool to toggle all TRIMS in a script to LTRIM(RTRIMS()) and vice versa to make it easier to adapt scripts when moving between server version.

    Thanks,
    Mad Character Trimmer

    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)
  16. Our dev group versions our styles. A small change between style versions can cause numerous changes in a single file making peer reviews more difficult than they need to be.

    My suggestion is to add an Format > Styles > Actions option to add style stamp. Implementation would be adding a comment with a style/version stamp at the top of the file when a format is applied. If the comment exists prior to formatting, that style will be used by SQL Prompt regardless of selected style. If the style/version is not found, the selected style is used. To change which…

    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

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 'History for SQL Queryxxx' pane - there are too many versions. I don't need a version for every minor change. How about adding an option for how often to save versions?

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

    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

    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)
  19. Occasionally I must edit the definition of a computed column. As editing a computed column is not allowed from SQL, would be nice to generate a script that would facilitate this update, similar to the rename script. (Ie, drops indexes, drops the field, recreates the field, and recreates the indexes.)

    Obviously this is similar to the functionality of the Smart Rename, except doesnt' have to edit Views and Sprocs, so hopefully most of the logic could quickly copy over from there!

    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. When you open the command pallet the tools under the Commands tab like 'Add Commas' and 'Add Quotes and Commas' are extremely useful. It would be a tremendous time saver to not have to get to them via the menu and simply be able to assign them to Shortcut Keys and/or Toolbar buttons. There are quite a few options that can be assigned to buttons, but not these. Please consider adding this feature.

    Thanks,
    CommaChallenged

    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)
← Previous 1 3 4 5 31 32
  • Don't see your idea?