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

78 results found

  1. When SQL Prompt loads the database objects, the resolution on my Dell M3800 gets screwed up. I can restore it by checking for 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

    declined  ·  Ali responded

    Hi

    Thanks for your suggestion. This sounds more like a bug than a feature, although we’re not currently aware of it. Please could you raise a support ticket with screenshots and recreation steps at: https://redgatesupport.zendesk.com

    Thanks

  2. Hi support,

    Please add TRY_CAST to you list of key words in SQL Prompt.

    Best regards,

    Henrik

    Henrik Staun Poulsen

    Vestas Data Center

    Vestas Technology R&D

    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

    declined  ·  Aaron Law responded

    Hi Henrik,

    Unfortunately the script syntax highlighting is not handled by SQL Prompt. It’s something that’s built into SSMS and so we don’t have control over which keywords get marked as pink.

  3. 1º Disable/enable duplicate parentheses correction ))* option
    example : Select ISNULL(dbo.InitCap()
    in * position to tipi parentheses ')' SQL Prompt eating this
    res: Select ISNULL(dbo.InitCap()

    2º right-click > Format SQL > [Sub Menu] Style
    , for quick access to alternative formatting setting
    3º I Still Waiting For Numeric Data type LENHT in definition box, tooltips and suggestions box
    and 4º most importantly is highlight similar words

    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

    declined  ·  Aaron Law responded

    Hi David,

    I’m going to close this idea as its really 4 ideas which means it’s difficult for us to know which one to work on if other users start voting on it. We also already have individual ideas for each of these so closing this one will give you the points back and allow you to add them to those.

    Thanks,
    Aaron.

  4. Executing code on multiple servers and with check boxes choosing on which to execute for fast on/off.
    Also procedure comparison and altering on multiple servers.
    So all in all enabling easy management for multiple servers and instances of SQL Server. Registered Servers feature in SSMS i just too blunt.

    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

    declined  ·  Aaron Law responded

    Hi Hrvoje,

    I’m going to decline this suggestion as I don’t think it fits in with Prompt at the moment. We have another product called SQL Multi Script that has some of the functionality you’re requesting for multiple servers.

    Thanks,
    Aaron.

  5. The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking

    For Example,

    User types:
    SELECT Master.Active,

    Prompt now makes it

    SELECT m.Active -- Cursor stays here
    FROM Master m

    We still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.

    Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.

    This feature is also more natural to find because the developer…

    19 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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    We’ve reviewed this as part of our UserVoice triage.

    Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.

    Please feel free to send us any additional feedback on these topics by commenting here.

    Kind Regards,
    The Prompt Team

  6. SSMS shuts down when I bring my computer back from sleep mode. I think it's due to SQL Prompt. Also, SQL Prompt could do a better job recognizing CTE's. Furthermore, when referencing a table function in a query the formatting is very clean. It often times puts each string input on a new line. Formatting should be improved around strings / inputs separated by commas.

    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

    1 comment  ·  Admin →
    declined  ·  Aaron Law responded

    Hi Devin, I’ve sent you an email asking for more details on the bugs you mentioned but I’m going to close this idea as it’s 3 in 1 which makes it awkward to complete or vote on.

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

    declined  ·  Aaron Law responded

    Hi Eric,

    We haven’t received a response and are unable to recreate this bug here so we’re going to close down this feature request. If you’re still experiencing this please send us some more details.

  8. Developing a script of some size becomes very tedious when going back and forth, and the script quickly becomes unwieldy.

    Add collapsable regions driven by specially formatted comment (--#Region [name/description/comment] ... --#EndRegion, or some other suitable notation).

    70 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

    11 comments  ·  Format SQL  ·  Admin →
    declined  ·  Andrei Rusitoru responded

    We’ve had a look at this feature and found a potential existing solution using
    BEGIN END blocks in SSMS 2016+

    e.g.

    BEGIN —this is a “region”

    SELECT * FROM TEST;

    END

    We’re not planning to do this in the near future because of the effort required to support all versions of VS and SSMS that Prompt is available on.

    Kind Regards,
    Prompt Team

  9. WIth the change in v6 to default to

    SELECT * FROM table1
    INNER JOIN table2
    ON table2.id = table1.id

    whereas previous versions used this format.

    SELECT * FROM table1
    INNER JOIN table2
    ON table1.id = table2.id

    If upgrading from an earlier version, can either the swap order option be enabled or at least the user warned during installation that the intellisense options have changed and that queries will be formatted differently.

    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

    declined  ·  Aaron Law responded

    Thanks for your suggestion Kieron.

    In adding this new option, we set the default column order to what we think will be the most useful. If you prefer the old behaviour, select the new option – your option preferences will be persisted when you install new versions of SQL Prompt.

  10. When you format:

    SELECT x from y

    ;WITH NumberSequence ( MonthNumber )
    AS ( SELECT 1 AS MonthNumber
    UNION ALL
    SELECT MonthNumber + 1
    FROM NumberSequence
    WHERE MonthNumber < 12
    )

    You move the semicolon to the end of the previous command instead of leaving it with the CTE and remove the blank line:

    SELECT x from y;
    WITH NumberSequence ( MonthNumber )
    AS ( SELECT 1 AS MonthNumber
    UNION ALL
    SELECT MonthNumber + 1
    FROM NumberSequence
    WHERE MonthNumber < 12
    )

    Should leave the blank line and semicolon where they are.

    Thanks,

    Tom

    20 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

    7 comments  ·  Format SQL  ·  Admin →
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    We’ve reviewed this as part of our UserVoice triage.

    We’ve decided not to implement this feature as there is not enough evidence/demand at this point in time to justify its implementation.

    Kind Regards,
    The Prompt Team

  11. I'd like the ability to align my parenthesis with the start of the line above it like so:

    SELECT
    column1
    ,column2
    ,column3
    FROM
    table1
    WHERE

    tableID IN
    (
    1
    ,2
    ,3
    )

    I would also like the option to never insert more than 1 space between words in a line.
    I don't like that there is a full tab between WITH and TARGET below. TAB the whole line or nothing. I can't find a way to get rid of this.
    ;
    WITH TARGET
    AS (
    SELECT
    Column1
    ,Column2
    ,Column3
    FROM
    table1
    )

    A keyboard shortcut to add commas to a…

    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 →

    Stephen,

    I’m so sorry about the UserVoice formatting issues. I’m going to contact their support to see if this can be fixed. For now, can you please post this in our support forum at http://www.red-gate.com/messageboard/viewforum.php?f=137.

    Davin,

    I’ve declined this suggestion because it contains too many suggestions. Please post each suggestion separately so other users can vote on individual suggestions, which will help us prioritize work. There are some really good ideas here and we appreciate the feedback.

  12. When you are working with SQL it is easy to forget the "where" statement in update, delete. If this happens in production it could be devastating. It would be a nice feature to automatic add the "where" statement in for "delete" and/or "update".

    19 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

    5 comments  ·  Format SQL  ·  Admin →
    declined  ·  Frederico Jeronimo responded

    Thank you for the suggestion.

    Prompt already provides execution warnings when you use an UPDATE or DELETE statement without a WHERE clause and code analysis also flags this as an issue. Please see the comments below for other options for solving this issue.

    You can get the latest version of SQL Prompt, including all of the above, from http://www.red-gate.com/products/sql-development/sql-prompt/.

    Thank you for your help!

    Kind regards,

    The Prompt Team

  13. My coding preference is to place commas at the beginning of a line, NOT the end. Can you make the placement a config option?

    If you would like I can explain why this is much better than having them at the end of the line.

    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

    2 comments  ·  Format SQL  ·  Admin →
    declined  ·  Aaron Law responded

    I’m declining this suggestion as we already have this option under Format→Commas & parentheses.

  14. There is a tool called SSMS ToolsPack (http://www.ssmstoolspack.com) which contains a number of useful tools, such as color-coding windows (which is now an experimental feature in SQLPrompt, but the other set allows you to choose your colors). One of the tools I use with unfortunate frequency (and has saved my bacon numerous times) is their "Query Execution History" feature; this saves every single query you execute with connection information, date/time stamp, and what file name it was executed from. If you've ever had to go "What was that ad-hoc query I wrote but didn't save?" this feature can…

    39 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

  15. It would be really great if you were able to export the data to file, or document, spreadsheet. Almost a way to obtain sample 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

    declined  ·  Aaron Law responded

    I’m going to close this feature request as we have removed the data explorer feature from Prompt.

  16. When Typing

    UPDATE MyTable and then press TAB
    it would be nice when SQL Prompt would generate
    UPDATE MyTabLE SEt
    MyField1 = @MyField1,
    MyField2 = @MyField 2
    etc

    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

    declined  ·  Thomas Walsh responded

    SQL Prompt has support for auto-completing INSERT statements which as of version 9.3, can be automatically refactored into an UPDATE statement, which should achieve a similar result to what has been requested.

    Kind Regards,

    The Prompt Team

  17. It would be nice to compare 2 objects (tables / stored proc ets), by right clicking on them and select to compare (lig scema compare).

    I am using to to clean up an old DB with a lot of copyed code and tables.

    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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  18. I use many "as" clauses in my selects. If I need to use a Group By clause, I can copy my Select items, but then I have to manually remove all of the "AS" clauses. It would be a dream to have them removed during a format!

    Also, what would be involved in having a "change to other favorite connection" mechanism, so I can switch my current query between production, development and test? And it would be doubly sweet if the switch also changed to my usual db on that instance. Like an Alt-Tab allows you to switch between open…

    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

    1 comment  ·  Format SQL  ·  Admin →
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  19. Allow starting a query with the FROM clause (ala LINQ) and provide intellisense normally. I would continue normally, right up to the point the user types the select update or delete keywords, at which point you either automagically reposition the keword and cursor to the top of the query, or allow the user to finish and then prompt for query restructuring. This would completely do away with the mucking around of doing a ssf and then going back later to fill in the list! In fact, I'd take it a step further and offer to restructure poorly written queries..e.g., If…

    8 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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  20. I have been using SQL Prompt with SQL Server for quite a while and have gotten use to the features. I now work with SQL Server CE within Visual Studio and don't get to take advantage of the SQL Prompt features. It would be nice if SQL Prompt worked in the SQL editor in Visual Studio when using sqlce files.

    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  ·  Admin →
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  • Don't see your idea?