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 at https://forum.red-gate.com/categories/sql-prompt

Update (Jan 2019):
To help with internal prioritisation, suggestions with no customer activity in the last 90 days have been archived. Thank you to all users who have contributed, we still want to hear from you so do keep suggesting/voting. If you have any concerns that a suggestion has been incorrectly prioritised please do resubmit or get in contact.

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. THEN expression on same line as keyword

    Current formatting is:

    CASE
    WHEN 1 = 1 THEN
    'Hello World'
    END

    I need the option to put the expression on the same line:

    CASE
    WHEN 1 = 1 THEN 'Hello World'
    END

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    • Comment in /* */

      Is it possible to add a hard return after the /* comment */ block so code doesn't keep formatting after the comment

      Currently:
      /* comment */ UPDATE User
      SET Modified = CAST('2018-12-20' AS datetime)
      WHERE id = 255454

      Suggestion
      /* comment */
      UPDATE USER
      SET Modified = CAST('2018-12-20' AS datetime)
      WHERE id = 255454

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
      • Add $Query$ to execute when inserting a snippet

        Add $query$ to SQL prompt that allows you to define a query which get executed and the results pasted in place, optionally formatted as VALUES statement

        I currently have a snippet that runs
        SELECT '(' + CAST(r.RegionId AS VARCHAR(50)) + ',''' + r.RegionDescription + ''',0),'
        FROM retail.Regions r
        WHERE r.ActiveTo > GETDATE()
        ORDER BY r.RegionDescription

        I then copy the output and use the $paste$ place holder in another snippet to paste in

        DECLARE @regions TABLE (RegionId INT, RegionDescription VARCHAR(50), Active bit)
        INSERT @regions (RegionId, RegionDescription, Active)
        VALUES
        --$PASTE$ goes here
        (117,'Anglia',0),
        (119,'Greater Manchester',0),
        (145,'Hampshire',0),

        An improvement would be remove the…

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
        • Change the activation model to allow easier portability

          As a consultant I move around to many computers. I depend on this product, but it is often a chore to keep track of where it is active. It would be a real quality of life improvement if I could just login to the machine I'm using and type in my redgate creds to activate sql prompt and get on with it. So often I'm running into an activation error, followed by a support call to find where the product is in use, then deactivate it, the activate on the new machine repeat, repeat, repeat...

          I understand you make money…

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
          • Bring back the Ctrl+B, Ctrl+B hotkey for removing square brackets please. I used it all the time and the last update seems to have removed

            I updated to SQL Prompt 9.4.7.7595 yesterday and since then I no longer have the hot key. It is still on the menu, but no hotkey. I used that feature hourly. If you wish, allow users to define the hotkey combinations or disable them, but simply removing them is inconvenient.

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Add Support for Microsoft Analytics Platform System

              If a sql command is written with an APS specific statement (for example: "CREATE TABLE AS, or "OPTION (Label = 'Query Description')" ), then a script parsing error appears.

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
              • SQL Prompt Code Visualization (Like Flow Chart)

                SQL Prompt should be able to Visualize the Code and represent the code like Flow Chart.
                This Feature will be very useful while working with heavy Stored Procedures.
                The Sample Code Visualization image is shared below:
                --
                https://drive.google.com/file/d/1dE0H7UP1MOuOZ4A3e4urUkDlR0FD4474/view?usp=sharing
                --

                8 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  2 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                • Issue code SC003 when USE is first line

                  Issue code SC003 shouldn't happen if the USE statement is at the top of a SQL script.

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                  • Prefixes in function parameters

                    SQL Prompt is removing prefixes from column names used as parameters in function-calls. For example, if you use Cross Apply to a system function:
                    SELECT *
                    FROM sys.tables AS T
                    CROSS APPLY sys.fn_listextendedproperty('blah','schema',schema_name(T.schema_id), 'table', T.name, null, null)
                    It removes "T." from schema_id and name in the parameters list. This means I have to add them back in if the column names are ambiguous. I don't see a setting for this, and have Prompt set to add prefixes to columns in the other clauses. So it'll add "T." to a column in the Select clause, and remove it from the same…

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                    • Trim white space

                      Please add an option be added to SQL Prompt to trim all white space.

                      Ideally, the following would be supported:
                      - Ability to execute against a query window or block of selected code
                      - Available as a stand-alone shortcut
                      - Can include as part of a Format SQL style
                      - Option to remove a) leading spaces, b) trailing spaces, c) both

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                      • Apply casing formatting as I type, but without the suggestions.

                        Currently, SQL Prompt either allows you to apply casing all at once with the Apply Casing Options, or it does it as you type if Enable Suggestions is turned on.

                        Please add a feature so that I can have casing applied as I type, but without the suggestions.

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                        • Support 'FROM BINARY' in CREATE CERTIFICATE

                          Support 'FROM BINARY' in CREATE CERTIFICATE

                          Since SQL Server 2012 there is an option to specify an ASN-encoded binary certificate when doing ‘CREATE CERTIFICATE’. Alongside CERTENCODED() and CERTPRIVATEKEY() this makes for a good way to transfer certificates generated on SQL server to other stages.

                          Your formatting engine however does not recognize the BINARY-parameter of said statement. Please include it as valid syntax.

                          Examples (non-working because the certifcates are fake – but you are free to generate your own; note that passwords are optional):

                          CREATE CERTIFICATE [TestCert] AUTHORIZATION [dbo]

                          FROM BINARY = 0x42

                          WITH PRIVATE KEY ( BINARY = 0x42, DECRYPTION…

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • A Create/Declare Table statement with a Primary Key gives a false positive BP014 in Code Analysis

                            If you have a table declared like this:
                            Declare @Test table
                            (TheKey int Primary Key,
                            SomeData varchar(10) Not Null)

                            I am told that for "TheKey" "[NOT] NULL option is not specified in CREATE/DECLARE TABLE statement" defined. But, a Primary Key can never be null, so it is NOT NULL by nature.

                            So, when performing Code Analysis and the parser sees "Primary Key", "Not Null" should be inferred also.

                            1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add support for SSMS preview candidates

                              Some people uses the latest versions of SSMS. I'd like to see it in non-release versions, maybe not fully supported yet.

                              0 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add formatting support for OFFSET and FETCH NEXT

                                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.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Make SQL Prompt & SCG Command line ignore code where scgignore is set

                                  We have adopted SCG and have commented out areas of code we do not want checking with scgignore. The new version of SCG command prompt and SQL Prompt do not recognise these comments, and report the area of code with warnings.
                                  Please amend so they are not reported, or at least reported differently so we can ignore.

                                  0 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add option in context menu to "Open In Browser"

                                    When the grid outputs a link as its value, right clicking the cell would provide an option to "Open In Browser"
                                    ...
                                    Additionally, this same functionality could be customizable (perhaps a customize context menu section within SQL Prompt options) to allow for other applications, wherein the highlighted/cell value is passed as a parameter to a given application. This would be similar to the External Tools, which is provided within SSMS, but having that option right there in the context menu would be gold.

                                    So, in the case of a URL, I right click the cell, choose Open In Browser, and…

                                    1 vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Allow importing of .settings file, and setting Code formatting/snippets folders and default formatting style to be done via Command line

                                      I would like to be able to better automate our onboarding process for new developers by helping ensure their snippets folder, formatting style folder and default formatting style are correctly setup. Additionally we would like to be able to automatically import settings from UNC/source control for them. This reduces the inevitability that something is missed when trying to follow a setup guide we have to additionally maintain. Thanks!

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                      • ST008

                                        I'd like to vote for adding ST008 (non-named parameter style used) to the issues which can be auto-fixed. Hopefully it would be fairly simple to implement.

                                        1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Use named parameters when encapsulating as new stored procedure

                                          It would be nice if the "Encapsulate as new stored procedure" logic used named parameter style so I don't immediately get ST008 in my code which calls the new proc.

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • Don't see your idea?

                                          Feedback and Knowledge Base