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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

715 results found

  1. I would like to see the ability to copy a selected row or a number of cells in a grid, and add it to the clipboard as a transposed view of the record
    with 2 columns (Column Name, Value) to allow results to be easily pasted into emails etc

    example (simple result only the result values would need to be selected)
    ID Name Activation Date
    1234 John Smith 2018-01-14

    output on clipboard

    ID 1234
    Name John Smith
    Activation Date 2018-01-04

    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)
  2. Issue code SC003 shouldn't happen if the USE statement is at the top of a SQL script.

    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)
  3. The Format SQL command currently overlooks these keywords and they end up appended to the last line of the ORDER BY clause. Ideally, I'd like to have the option to place both OFFSET and FETCH NEXT on separate lines, aligned just like the SELECT, FROM, WHERE, and ORDER BY keywords.

    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)
  4. What I sometimes run into, is that a table gets an alias (by SQL prompt), that matches an acronym for a snippet. Then, whenever I'm writing out my query, while calling the table by alias, snippet manager replaces the alias with the full snippet. Which can be annoying as Ctrl-Z doesn't work.

    My suggestion would be to check the snippet manager before assigning aliases and not have them overlap.
    Thanks.

    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

    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)
  5. Would be great if SQL Prompt Code Analysis would give a warning on SQL Below:

    SELECT CAST( 1.453 AS DECIMAL)
    SELECT CONVERT(DECIMAL, 1.453 )

    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)
  6. EXEC spwho2 without return (EXEC @Results = spwho2)
    Give a warning when tsql or stored procedure has execute a stored procedure without a variable for an error to bubble up to.

    This is the proper way because ieven in a try catch the Exec sp_who2 won't give and error to stop the tsql from going on

    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)
  7. Add rule for deprecated DATABASEPROPERTY

    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. My default preference is to maintain the ON keyword without a new line. I would like to be able to CONDITIONALLY place the ON keyword on a new line if, and only if the ON keyword together with the associated ON condition exceed a configurable wrap threshold.

    Example:
    -- Yield this >>>>
    SELECT *
    FROM Person.Address
    INNER JOIN Person.StateProvince
    ON StateProvince.StateProvinceID=Address.StateProvinceID
    -- >>>> instead of

    SELECT *
    FROM Person.Address
    INNER JOIN Person.StateProvince ON StateProvince.StateProvinceID=Address.StateProvinceID
    -- Assuming the JOIN clause exceeds the wrap length
    -- <<<

    This is particularly useful if the "Place JOIN table on new line" is NOT selected…

    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)
  9. It would be cool if SQL Prompt was able to remove trailing whitespaces/tabs not only for T-SQL, but also for comments.

    It's not something crucial, but rather nice-to-have

    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)
  10. When using SQL server 2016 with a database that has it's compatibility level set to 2012, I'm still being offered auto complete options for 2016 features. e.g. string_split

    SQL Prompt needs to detect the database compatibility level and adjust it's intellisense accordingly.

    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

    1 comment  ·  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)
  11. It would be very helpful if there was an outline for the script being edited. Say, a script has many "CREATE PROC"s. We could have a tree or a list or a drop-down, to view a list of CREATE PROCs and click to scroll to the section.

    If a tree style is selected, this could be expanded into seconds inside each PROCs.

    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)
  12. Bookmarks is a feature of SSMS. But all my bookmarks are destroyed once the code is formatted. So, as SSMS' feature is not so good as I want I do suggest to implement this feature by RedGate.

    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)
  13. I think SSMSBoost has this feature: being able to add configurable guide lines to limit the query writing space to a specified number of characters/columns. This is very handy as I always want to keep my code narrow, within the 80-char limit. Currently, I have to install SSMSBoost for it... Could this please be added to SQL Prompt? This is probably a quick feature to implement and would be tremendously useful. Thanks.

    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

    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)
  14. If format SQL makes chnages - it destroy saved marks
    This occurs even when line bookmarked line hasnt (visibly) changed
    Very frushtrating

    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)
  15. Currently, the "Add/remove square brackets" action is all-or-nothing. If I select "remove unnecessary," it strips brackets off columns named after reserved words (like date, user, type) because SQL Server technically allows them. However, this ruins syntax highlighting and code readability.
    Please add a formatting style option to: "Enclose reserved words/keywords used as identifiers in square brackets" while still allowing the engine to remove unnecessary brackets from normal columns (e.g., changing [MyTable].[MyNormalColumn] to MyTable.MyNormalColumn but leaving/adding brackets to [date]).

    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)
  16. Make ConnectionColoringServers.xml meant to be edited and shared in the way that allows it to be copied to other servers for centralized coloring styles. I attempted to manually edit this and share it and was told by Development that his was a feature request. Refer to Redgate Ticket #362813.

    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. Whenever SSMS starts, SQL Prompt checks to see whether the Redgate Assistent is available, and this takes a little while.

    I would like to be able to disable this startup check in options.
    There is a option available to disable it, but it is already unchecked, properly due to check startup check.. But it would be nice to be able to disable it completely, so there is no startup check

    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  ·  AI  ·  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. It would be helpful to have a snippet placeholder called $FILENAME$ that inserts the current script filename. Many of us are using database projects with SSMS, Visual Studio Code and Visual Studio where SQL objects each have their own file in the project.

    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. For suggestions, auto-complete, and code analysis, very large SQL scripts cause excessive latency and can crash SSMS.

    Please add an option where a file that is longer than N lines will not be automatically scanned/validated.

    Use-Case: Complex database build scripts, schema source files, or other scenarios where a script can be tens of thousands of lines long require me to disable SQL Prompt before opening. Failure to disable SQL Prompt results in minutes of excessive latency and the inability to move the mouse around easily, type, or take any actions. This often leads to crashes, as well, either of the…

    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. Could you please consider adding support for phishing-resistant MFA? Currently, it is not supported.

    When staff attempt to authenticate using their passkey, the application displays an error indicating that this feature is not supported. I have been in contact with Red Gate support, and they have advised me to raise this request for consideration in a future release.

    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?