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

663 results found

  1. In prior versions, SQL Prompt would connect open queries as SSMS was opening but it would not refresh suggestions (index associated database) until an open query tab was activated (selected).

    The current version (10.13.3.32087) still connects open queries but it also refreshes suggestions for all open queries as it is connecting them.

    This leads to a sluggish experience with both typing and an increased delay in the time it takes for SQL Prompt suggestions to display. I suspect it is due to the large amount of cached suggestions.

    I typically leave many query tabs open when working in SSMS so…

    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. We add certain standard columns to all tables (LastUpdatedDate for example). Would be great to be able to set a list of these columns in the Options so they can be excluded from list of suggested JOINS

    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. I am installing SQL Prompt into SSMS only. every time I run an update I need to change the install location to SSMS only (from SSMS and VS). Please make the installer remember my selection and default to it

    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. It would be nice to have a setting per database in SQL Prompt that would allow us to set an alias to tablename mapping and these settings can be shared / stored in source control for other developers.

    When we run the qualify object name operation it could look at this dictionary and automatically inject an new alias for an old alias or table/view with no alias.

    This allows us to have consistently alias'd tables across all sql objects in source control.

    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)
  5. Add a new window that compares the output (and speed) of two stored procedures using the same parameters (ignoring parameters that are missing on either side).

    When fixing performance problems or adding new parameters to existing stored procedures, we often need to rewrite large portions.
    After successfully speeding it up, we need to test if the results are still correct.
    One way to do this is to compare the output of the new procedure with the output of the old one using different parameters. This involves storing results in temp tables, sorting them, output to a text file and using…

    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. Qualify object names [Ctrl+B;Ctrl+Q] should also clean up three and four part column references

    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)
  7. It would be appreciated if you could enhance the SqlPrompt Formatting Styles functionality. I believe this would go in the STATEMENTS >>> Data (DML) section.

    I'd like to continue using the "If there are multiple expressions" item of the "Place GROUP BY / ORDER BY expression on new line" drop-down. But I'd like those expressions to be indented; they presently all left-align to the GROUP BY.

    Also, while you're there, it seems that it would be good to also have add an "If longer than wrap column" option to the above-mentioned drop-down.

    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)
  8. For tabs with an open connection, show the SPID # in the list on the left side

    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  ·  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. Allow dark theme for all GUI interfaces in Prompt.

    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. It would be very useful to be able produce where clause from copied horizontal selection from the results grid. For example from the uploaded image, where clause should be

    WHERE CTA.TRANSACTIONDATE = '2021-06-27'
    AND CTA.TRANSACTION
    TYPECODE = 52
    AND CTA.ITEM
    CODE = 1500012200
    AND CTA.ITEMBARCODE = '8001841964966'
    AND CTA.YOUR
    COMPANYCR = 104183
    AND CTA.OTHER
    ENTITY_CR = 46084

    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)
  11. Be able to refactor INSERT statement into UPDATE statement that has SELECT rather than VALUES i.e. "insert into xxx select from".

    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

    1 comment  ·  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)
  12. The current parenthesis options I have set for an INSERT INTO (DML) statement, only appear to work for the list of columns, but NOT for the list of values in the VALUE clause. I'm unsure why this behaviour is different, but this inconsistency seems like a bug.

    I have provided a screenshot where you can clearly see the parentheses are not aligned correct in comparison with the INSERT statement.

    Ultimately I would like for the formatting to be overall consistent.

    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

    1 comment  ·  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)
  13. At the moment a user is warned before executing a potentially dangerous operation.
    However, junior devs might accidentally just press enter without thinking twice.
    Please add functionality to PROHIBIT execution besides WARNING (like SSMS Boost has) so that junior devs can't make mistakes at all.
    It would be fantastic if this would be possible.

    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)
  14. Make the column picker the default tab when suggesting columns when the ursor is inside a select statement.

    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. Automatically insert a snippet as soon as you start a New Query in SSMS. I want all my developers to always start every script with a comment block with their username, date and a description of what the script is supposed to do. A shared snippet is already handy for this, but adding this could make it easier to build that habit for new team members.

    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. F12 to Script views and stored procedures as ALTER is one of my favorite features. I would love it if F12 when I am on a table generates a CREATE TABLE script for that table.

    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 have included a Sample SQL script. This script shows the desired formatting. I can't find any way to prevent the OPENJSON from being sent to a new line. For example:

    SELECT *
    FROM OPENJSON(@JSON, '$.Doc') AS OJ
    CROSS APPLY OPENJSON(OJ.Value)
    WITH (ID int) AS CAOJ

    becomes

    SELECT *
    FROM OPENJSON(@JSON, '$.Doc') AS OJ
    CROSS APPLY
    OPENJSON(OJ.Value)
    WITH ( ID INT ) AS CAOJ

    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

    1 comment  ·  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)
  18. After running a select statement, I want to be able to copy selected column headers without copying any data.

    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)
  19. "Script as INSERT" creates an INSERT script with a tempt table, but instead it should script the current used table.
    In that way you can easily write scripts to synchronize your data between different environments.
    Thank you

    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. Consider I've got a variable of varchar(35)

    I perform an update on a column of varchar(10), it should suggest that there will be a truncation

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