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

689 results found

  1. I've used SQL Prompt for 20 years. I would LOVE VSCode integration.

    95 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 love the immediate suggestions when I need/want them, however when I do not want them, the suggestion box ends up blocking my screen more than it helps (Often blocking code I want to reference in a future query) and there is not a good way to make the suggestion box go away without clicking away from wherever it was suggesting.

    I know I can delay the popup and manually show suggestions with ctrl+space, but I would love to be able to manually hide them as well with ctrl+space as a simple toggle. It would greatly help me and other…

    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)
  3. Tried to test out the new Prompt AI feature and cannot use it to generate SQL as the DB has more than 4000 objects (over 6000 actually). It would be great to limit the schemas within the DB where I want the AI tool to "know about" so that A) it keeps the AI focused on just the schemas it needs to answer most questions and B) it keeps the overall list of objects and time needed to poll them more manageable. In absence of this, allow more objects.

    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)
  4. format grouping sets in the same way as other lists.
    currently they are made into one long line regardless of the wrapping setting.

    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)
  5. This is needed because I am required to run SSMS with elevated rights.

    My regular Windows login doesn't have access to my database servers, and my elevated account doesn't have access to my MS 365 office suite.

    Because of this, the "Open in Excel" feature is not useable.

    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 would love a warning to prevent the classical mistake of comparing a column with itself instead of with another column in a WHERE clause.

    An example is the following, where I would like a warning where one has "qlpd.interimdisbursementid = qlpd.interimdisbursementid" as it should be qlpd.interimdisbursementid = di.interimdisbursementid instead:
    SELECT *
    FROM dbo.datinterimdisbursement AS di
    INNER JOIN dbo.qliro
    logPayoutServicedata qlpd
    ON qlpd.interimdisbursementid = qlpd.interimdisbursementid;

    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 would like the ability to select 1 or more values in a result and have the (right-click?) option to select header(s). I then have the header, or headers separated with commas in my clipboard.

    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)
  8. I would LOVE! the ability to have a search window with my results from a query, where I type in any part of a column name and it lists all columns containing value I typed in.
    By default one is positioned on the applicable column in the result (scrolling if necessary in wider result set), but if one clicks on any column matching value then it positions one on that column in the result.

    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)
  9. The error popup comes out of nowhere when navigating SSMS tree nodes, notably when selecting a specific database name. I expected it came from SQL Prompt, but there was nothing being logged even when verbose option has been enabled.

    The support helped clarify it "probably" came from SQL Source Control installed recently.

    Also, the "Send Error Report" never worked.

    The error completely freezes SSMS as it is a modal.

    It has to be dismissed multiple times and then navigated away from the selected database back to a server's name - quickly using a keyboard.

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

    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)
  11. Working with a query that contains the same expression multiple times, I often want to extract all instances of that expression into a CROSS APPLY for readability and ease of modification, e.g. converting something like this horribleness:

    select foo = case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end, count(*)
    from baz
    where case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end in ('a','b')
    group by case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end

    into something more manageable…

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

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

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

    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)
  15. When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.

    However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.

    While it may be advantageous to have this rule enabled, it would also…

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Tab coloring doesnt work in vertical tabs mode

    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)
  17. I would like a feature that allows a user to right click on a variable name and allow for an option of Go To Declaration so it would scroll up to the place where the variable is declared. The hover option shows how it is defined, but not where it is defined which is also extremely helpful when troubleshooting and researching a script.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.

    Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.

    In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.

    In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.

    Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt…

    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  ·  Intellisense  ·  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. How can we get the following alignment with nulls? Please review the pre & post images attached

    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)
  20. This is an extension of:
    https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6779217-add-n-to-unicode-type-literal-strings

    Except I would like to improve this feature so that it is not limited to just variable declarations, but also for inline string literals.

    For example, if an inline string literal contains a unicode character, it should have the N prefix. If anything it should probably be a Code Analysis rule rather than formatting because this change can absolutely impact code behavior. So I think it's better suited to be an analysis rule.

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