277 results found

1. Command Line "Reformat All Files In Folder" and pre-Commit

   Opening over 2500 code objects to set a baseline format, required by a large customer, is a daunting manual task.

   Many of Red Gate's tools provide command-line functionality.

   Please add it to Prompt so we can bulk (re)format SPs, UDFs, Triggers. Integration into the commit-path (we use SVN) would be ideal for standardized check-ins (Commits).

   Can't recall whether a style is exportable... (License key awaited at new employer) Should be able to point to UNC location for the style to use.

   109 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   28 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   completed  ·  Adminjames.hemson (Admin, Redgate) responded

   Bulk operations for formatting and code analysis were added as part of SQL Prompt 10.7

   Bulk operations in SSMS - SQL Prompt 10

2. Query Execution History

   Had this with SSMS Tools Pack but upon migrating to 2012 I ditched it in favor of SQL Prompt. The only thing I'm missing is a log of my Query History, time-stamped and searchable.

   106 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   27 comments  ·  Delete…  ·  Admin →
   completed  ·  Adminjames.hemson (Admin, Redgate) responded

   We've now released this feature in version 10.13

3. Synonym support

   I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
   Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for its columns etc. This renders SQL Prompt's auto completion and suggestions useless in many cases for us.

   I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
   Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for… more

   102 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   23 comments  ·  Intellisense  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   We’ve released SQL Prompt 6 which includes full synonym support.

4. Support Tab Magic in SSMS 2012 ASAP

   The VS-based "tool" is significantly less usable than SS2008R2. Tab Magic will significantly ease the pain of having to work with tabs in the limited manner SSMS2012 inflicts upon us, especially those of us livid over the loss of the MDI-mode!

   91 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  13 comments  ·  Tab history  ·  Delete…  ·  Admin →

5. Improve SQL code formatting options
   90 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   25 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   completed  ·  Andrei Rusitoru responded

   SQL Prompt 8.0 includes many improvements to the SQL formatting options. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

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

   Thank you for your help!

6. Automatic semicolons

   Include an option when reformatting SQL to automatically add semicolons at the end of each statement if they are missing.
   While in most cases SQL Server 2005 and 2008 don't require this, the 2008 docs mention that a future version might.
   and it may also be helpful if trying to move code from SQL Server 200x to a dialect which does require them.

   85 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   9 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

7. Refactoring INSERT into UPDATE

   I wish there where a shortcut/command to change a statement like

   INSERT INTO Mytable(Id,Code,Label) VALUES (@Id,@Code,@Label)

   in

   UPDATE MyTable
   SET Id=@Id, Code=@Code, Label =@Label

   Even if it looks trivial on this statement, doing it with a table with 10+ Columns might be cumbersome.

   79 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   14 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   completed  ·  Thomas Walsh responded

   We’re happy to announce that this feature is now included in SQL Prompt 9.3. For additional information see: http://documentation.red-gate.com/display/SP9/SQL+Prompt+9.3+release+notes.

   You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

   Thank you for your help!

   Kind regards,
   The Prompt Team

8. GROUP/ORDER BY Suggestions

   It would be nice, if the suggestions list for GROUP BY would include all the all the not aggregated SELECT list columns first.
   For ORDER BY, all the columns/aliases or their ordinal, and add checkbox for ASC/DESC.

   72 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   6 comments  ·  Intellisense  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   SQL Prompt 6.5 now suggests the non-aggregated columns first for GROUP BY, with aggregated columns suggested first in HAVING clauses. You can download this version from http://www.red-gate.com/products/sql-development/sql-prompt/

9. Rank suggestions by popularity

   I would like to suggest a ranking feature when the suggestions list appears. At my place of work, if I want to select out of the customer table I will often type 'cu' then tab the rest. However this is the snippet for creating a user. This is also useful when many tables begin with the same prefix, but one is used far more often than others. With ranking, the more an object is used, the higher up the list it will appear, like browser history entries in Firefox for instance. This would reduce the number of keystrokes necessary and speed up code creation

   I would like to suggest a ranking feature when the suggestions list appears. At my place of work, if I want to select out of the customer table I will often type 'cu' then tab the rest. However this is the snippet for creating a user. This is also useful when many tables begin with the same prefix, but one is used far more often than others. With ranking, the more an object is used, the higher up the list it will appear, like browser history entries in Firefox for instance. This would reduce the number of keystrokes necessary and… more

   70 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   15 comments  ·  Intellisense  ·  Delete…  ·  Admin →
   completed  ·  AdminTim Dalton (Product Manager, Redgate) responded

   On 14th May we released Prompt 9.5.3 which includes a feature to show recently used suggestions.

   This will be the first iteration of work to rank suggestions so we’re keen to hear feedback and ideas for improvement.

   More details in the release notes here: https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes

10. MFA (multi factor) Support for Azure SQL Databases

    Support Azure multi factor authentication for accessing Azure SQL Databases.

    69 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    19 comments  ·  Platform Support  ·  Delete…  ·  Admin →
    completed  ·  chiara.gardner@red-gate.com responded

    This was shipped in 10.4 https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-4-release-notes

    Thank you for your input!

11. highlight similar words

    Double clicking a word hightlights all instances of that word. This makes it easier to see where the word is used. Good for particularly long scripts.
    Double clicking a table, column, function, view etc. highlights all in your script.

    64 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  User interface  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

    We’ve added the “Highlight matching objects” experimental feature in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

12. Add options for CASE WHEN ELSE END

    I'd like to be able to configure a style for CASE statements using options like the following:

    • New line after THEN
    • New line before ELSE
    • New line after ELSE
    • ELSE match indent of CASE
    • END match indent of CASE

    It would also be nice to have a threshold setting (in number of characters) so the formatting settings are only applied if the length of a CASE statement exceeds the threshold.

    64 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    9 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

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

    Thank you for your help!

13. Disable SQL Prompt on certain blocks of code

    Add a functionality of disabling SQL Prompt auto-formatting feature for blocks of code. Use SQL comments for 100% sql compatibility. Example:

    SELECT 1, 2, 3
    --<SQLPROPMT disable>
    select 4, 5, 6
    --</SQLPROPMT>
    select 7,8,9

    in the code above, the first and third statements would be auto-formatted but not the second one.

    It would be especially useful for very long scripts where a single formatting template is not an option.

    64 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    13 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

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

    Thank you for your help!

14. Format SQL to Match Object Case

    If I had the table [Address] that had the columns StreetAddress1, StreetAddress2, City, State and ZipCode defined and the following existing code was formatted:

    SELECT streetaddress1,
    streetaddress2,
    CITY,
    zipcode
    FROM [address]

    I would like to see SQL Prompt match the case of the underlying object such that the results after formatting would be:

    SELECT StreetAddress1,
    StreetAddress2,
    City,
    ZipCode
    FROM [Address]

    This should apply to all underlying objects (procedures [name and parameters], tables [columns, index names (used in hints), etc., functions and views; and anything else I forgot). It should also apply to variables defined within a procedure (e.g. DECLARE @MyValue INT... SET @myvalue = 3. Subsequent SET/SELECT or other use of the variable should be formatted to match the case in the DECLARE statement so that the SET above would be formatted to SET @MyValue = 3).

    If I had the table [Address] that had the columns StreetAddress1, StreetAddress2, City, State and ZipCode defined and the following existing code was formatted:

    SELECT streetaddress1,
    streetaddress2,
    CITY,
    zipcode
    FROM [address]

    I would like to see SQL Prompt match the case of the underlying object such that the results after formatting would be:

    SELECT StreetAddress1,
    StreetAddress2,
    City,
    ZipCode
    FROM [Address]

    This should apply to all underlying objects (procedures [name and parameters], tables [columns, index names (used in hints), etc., functions and views; and anything else I forgot). It should also apply to variables defined within a procedure (e.g. DECLARE @MyValue… more

    63 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

    This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

15. Indent comments consistent with code

    I'm finding my comments are hanging out all on their own after the rest of my code is formatted. I would request a feature to allow comments to indent to the same level as the code on the line below.

    56 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    5 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

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

    Thank you for your help!

16. Add support for Azure Active Directory authentication

    Referring to this forumpost: https://forums.red-gate.com/viewtopic.php?f=169&t=79794

    55 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    8 comments  ·  Delete…  ·  Admin →
    completed  ·  chiara.gardner@red-gate.com responded

    This is now completed and was shipped in v10.4

    Thank you for your input!

    Chiara

17. TABS TABS TABS PLEASE

    In Format --> Tabs & Wrapping there is no option to keep and actual TAB character, instead a tab is converted to the user configurable number of spaces.

    This one is especially important for me because we have other code checking for TABS not (2,3,4,6,8) spaces. I now need to run a powershell script to convert the spaces back to a TAB.

    Would be great to allow TABS to remain as TABS.

    55 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

    We’ve released SQL Prompt 6 which includes support for tabs.

18. Option to highlight parenthesis matches

    In order for the braces/parenthesis highlighting to work currently, you must run the native Intellisense feature in SSMS, which creates some issues with SQL Prompt. If this were written in as part SQL Prompt, we'd be able to turn off Intellisense completely.

    51 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    7 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

    This is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/

19. Provide support for CLR functions

    The object text exists as normal for CLR functions (or at least enough for provide auto suggest on object name and number of params and types), therefore please can function which are backed by CLR be available in the suggestion list

    47 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    8 comments  ·  Intellisense  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

    This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

20. Highlight --TODO and --HACK comments

    When a --#TODO: or --#HACK is written on our code, it could be helpful to highlight it in order to give an alert to the reader. In addition it can be very helpful to let the user to configure the pattern (i.e. --#MyTerm).

    46 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Thomas Walsh responded

    We’ve released support for highlighting TODOs in version 9 of SQL Prompt as part of its new code analysis feature.

    You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

    We’re marking this request as completed, but if you feel strongly about being able to configure the term, please feel free to open a new suggestion.

    Kind regards,

    The Prompt Team