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

87 results found

  1. In the right-click menu of the "Tables" branch in SSMS, create an extra item that would retrieve string from system clipboard and apply it as an object name filter (using the SSMS built-in [Filter] => [Filter settings] => [Name] => [Contains] feature).

    This would allow for instant filtering, saving lot of time.

    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 use actions (from the ctrl menu) a lot. It would be extremely handy if I could re-do last action on the currently selected text by simply hitting Ctrl-Y (rather than hitting Ctrl and selecting it from the list of actions again and again).

    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)
  3. After I connect to multiple servers at one time using the Registered Servers window, the connected servers appear expanded in the Object Explorer window, and then I manually collapse each one. I also find myself scrolling up and down in the Object Explorer window to manually collapse servers I've expanded throughout the day. A menu item to collapse all of the connected servers in the Object Explorer window would be a feature I would use quite often.

    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)
  4. I got a suggestion from SQL Prompt for "Slow cached time detected".The link (seen in the screenshot) was this one:

    https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory

    So from what I understand, I need to manually go through all databases and schemas and select the ones I think are used to the most in order to only load suggestions for them, in order to improve performance?

    While I generally like SQL Prompt, the first word that came to mind was that this pretty much sucked, but let's just say it's less that optimal I think. Given that we’re in the ”AI age”, I was hoping that…

    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)
  5. 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)
  6. I often need to wrap a column in a coalesce with 0.
    It would be swell if there was a feature where I could select a column, then either right click or Keyboard shortcut to have it wrapped in coalesce.
    E.g. select the word
    personCount
    and have it be replaced with
    coalesce(personCount,0) as personCount

    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)
  7. It would be useful to have snippets included when searching in the command palette. Selecting snippet would open snippet editor with focus on the selected snippet.

    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)
  8. I would like to be able to specify different script blocks inside a snippet that would work differently based upon the sql server version of the server I am connected to.

    Or.... optionally have a version indicator on the snippet to perform the same thing. Then if two snippets share the same name it would apply the correct one based upon version.

    EX:

    :if $version_major$ >= 13
        CREATE OR ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN
            $CURSOR$SELECT @param1
        END
        GO
    :else 
        IF OBJECT_ID('[$dbo$].[$proc_name$]', 'P') IS NULL BEGIN
            EXEC('CREATE PROCEDURE [$dbo$].[$proc_name$] AS BEGIN SELECT 1; END;')
        END 
    
        GO
        ALTER PROCEDURE [$dbo$].[$proc_name$]
    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)
  9. I often find myself in a scenario where I am doing something like:
    1. Mock some data (SQL query)
    2. Perform a front end action as though I'm a user
    3. Check some data (SQL query)
    4. Alter a procedure (SQL query in a different window)
    5. Repeat

    I think it would be nice if I could pin the mock/check queries to a window in the side of the manager so that I could click to run them instead of having to click in them then shift+f5 or whatever. And even more nice not having to have a second editor…

    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)
  10. Tab Colors add a great feature to know I am on a production server. It would be improved by being accessibility compliant. In the attached you can see black on red is harder to see than white on red.

    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. 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)
  12. Surround with, add to the list Select, Pivot, and I am sure there are more items like CTE

    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. You should fix the use of multiple versions of your name (Red Gate | Red-Gate | Redgate | redgate | red-gate) across all software and communications. See attached picture.

    We try to promote your products in our consulting company, but everyone uses a different name to refer to your company.

    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)
  14. Hi, this is not related to SQL Prompt only, but to the update process in general.
    As our company firewall is blocking the link in Help "Check for updates ...", I have to submit the "Download a 28 days trial" form and download the full "SQLToolbelt.exe".
    Which is also blocked by the company proxy rules. :-(
    So I have to download the file on my private PC and then copy it to my business machine.
    I assume, my company is not the only one with such precautionary measures.
    Maybe you can implement additional options to download updates.

    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. It would be very convenient when going through legacy scripts to be able to hit a shortcut combination to switch the order of an equality statement, for example in a JOIN clause

    For example, with the cursor on "A.ID = User.AccountID":

    SELECT U.Username
    FROM Account AS A
    INNER JOIN Users AS U ON A.ID = U.AccountID AND U.Active = 1
    WHERE A.ID = @AccountID AND U.ID = @UserID

    Becomes
    SELECT U.Username
    FROM Account AS A
    INNER JOIN Users AS U ON U.AccountID = A.ID AND U.Active = 1 --note, only clause where cursor is is switched.
    WHERE A.ID = @AccountID…

    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)
  16. When right-clicking in the results tab, SQL Prompt should offer the posibility to copy the results as a table with markdown formatting (for Stack Overflow / Stack Exchange network). See https://meta.stackexchange.com/questions/356997/feature-preview-table-support for the syntax.

    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)
  17. When I right click in a Stored procedure SSMS hangs, and it takes too long for the menu to show up. Please review Red Gate Source Control for the added entries in the menu to improve performace

    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)
  18. This is essentially the same as a forgotten SSMS request over here: https://feedback.azure.com/forums/908035/suggestions/32896039

    It would be incredibly useful to be able right-click on a server-node in the Registered Servers list and change/set the connection for the current document window to that. You already have a custom context menu item in there ("Tab Color (Server)", so that hurdle is gone.

    This idea is related to these, but not quite the same. In both cases, it seems they don't know about the Registered Server functionality, so they're basically asking for this idea, plus for you to re-implement that entire feature.
    https://redgate.uservoice.com/forums/94413/suggestions/40385740
    https://redgate.uservoice.com/forums/94413/suggestions/13425135

    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. I love the 'Remove Comments' feature, however it takes too many clicks to implement. Please add it to the context menu.

    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)
  20. Hello,

    So I love the suggestion feature where I'm able to type in an object and the code appears to copy. Home run with this feature I can't thank you enough for it.

    I was wondering if it would be possible to expand on it though.

    Here is a sample. I'm looking to alter an object, let's say a stored proc...
    I usually begin by typing EXEC <name> to trigger the suggestion for stored procs to give me the object.

    Once the suggestion finds the object, the script contents appears in a side window.

    Using the COPY button in the…

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