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

637 results found

  1. 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)
  2. I would love an option where, after adding an alias to a table, you can add it as a prefix to all columns coming from that particular table at once.

    Some keystroke like Ctrl + F2 would be nice.

    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)
  3. Currently, SQL prompt doesn't support the windows certificate store like most applications do. The only way to work around that currently is to simply trust all certificates which is inconvenient (having to set this across potentially hundreds of server connections) and a security gap.

    SQL prompt should either provide an option to leverage the certificates. Currently, if a blanket trust is not provided, SSMS and SQL in general will work fine, but SQL prompt will cease to function, since the application (visual studio, SSMS) will connect correctly, but SQL prompt will not.

    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  ·  Platform Support  ·  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. 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.

    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)
  5. 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)
  6. I had a query which was using ROW_NUMBER() OVER (PARTITION BY ColumnA ORDER BY ColumnB, ColumnC) and FORMAT SQL command put the ORDER BY clause as the first thing on the line (no indentation). It would be better if, when it needs to be wrapped, the ORDER BY inside an OVER was indented to line up with PARTITION BY).

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

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

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

    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)
  10. 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)
  11. 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)
  12. Love the snippets functionality, but four improvements would be nice:
    1) Fix bug that if you click off a snippet to other windows before finishing it that it will lose everything you've entered and switch back to default values for everything.
    2) Add an option to finish a snippet when you tab past the final value instead of cycling back to the first snippet.
    3) When you hit ESC to exit a snippet, leave the cursor where it is instead of jumping to the end of the snippet.
    4) Allow user to define where the cursor should go when exiting…

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

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

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

    14 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)
  15. Allow save and re-load a set of filters. We work in schemas by project and every morning starts with filtering all my objects by schema, and I would love to reapply filters as a set.

    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)
  16. I've noticed that when I Expand * on a pivoted table, then the order of the columns gets reversed
    e.g.
    If I have something with a pivot
    Sum(Amount) for month_no in ([1],[2],[3]....)
    When the pivot result is expanded, it becomes [12],[11],[10]....
    Would be nice if the expansion would match the order that the columns was entered in.

    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  ·  Expand wildcards  ·  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. At times you do not always have the luxury to have SQL Prompt installed on all machines. Hence, it is extremely useful if snippets can be exported to a plain text file, so that at least one has the ability to retrieve the much needed sql scripts quickly via plain text files. It would be of great help if each snippet is exported to an individual text file that should be named like the snippet name.

    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)
  18. Database-specific snippets.

    We have 80 or so databases scattered across 200+ instances and many tables have similar names or identical names with differing schemas: compare person.personpe, dbo.person & finance.personpe. This particular is extreme and there are more examples but the principle applies.

    I would love to be able to define pe as a snippet at a database level so that I can keep my snippet names short and so that I don't have to rename them manually when I am in SSMS with a lesser used database.

    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

    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)
  19. Currently, FROM, WHERE, JOIN, and ODER can all be right-aligned to SELECT when formatting SQL. However, if you introduce a LEFT JOIN, the LEFT keyword is right-aligned to SELECT, and everything else is pushed over to make room for the JOIN. This is hideous and makes no sense.

    Instead, allow the entirety of "LEFT JOIN", "RIGHT JOIN", "INNER JOIN" and "OUTER JOIN" to right-align to the SELECT keyword.

    The attached images explain it better than I can.

    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

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

    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

    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)
  • Don't see your idea?