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

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. Format of Valid Selected Code when there is invalid code in the script (Take 2)

    Version 9.2.5.6073
    I would like to request that script validation be limited to the selected text during Format SQL.

    This is a duplicate of a Completed feature (Bug) submitted on version 7. https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/16611622-formatting-of-valid-selected-code-when-there-is-in
    I see recent comments on the original request but you may not be addressing since it is marked completed.

    To Replicate:
    Put 3 lines below in a new Window in SSMS

    SOME BAD TEXT
    GO
    SELECT 1 FROM dbo.Person

    Now select All of Line 3 after the GO Statement. Right-click, Format SQL

    Should get following error:
    "Error inserting semicolons" ...
    Script parsing errors:
    Line 1 Col: 1…

    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 →
    • IF Statement block formatting is messed up

      IF Statement block formatting is messed up

      IF 1 = 1
      BEGIN
      PRINT 'DO STUFF'
      END

      becomes

      IF 1 = 1 BEGIN
      PRINT 'DO STUFF';
      END;

      which is what I want...I want to leave the BEGIN END indention

      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 →
      • "Save As Excel" should also be an option, like Open In Excel is..

        I love Open In Excel, and I've even got it usable on a machine that doesn't have Excel installed. Thankfully you guys made SQLP so it creates the XLSX without needing Excel. That's cool, because it means I can do a fudgy workaround, setting Chrome to be my handler for XLSX files.

        Because Chrome doesnt know what to do with an XLSX other than "download" it from whatever temp file you guys create it in, it means when Chrome has finished "opening/downloading" the XLSX, I can hit Chrome's "Show in Folder" option and see the XLSX file in all its…

        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 →
        • "Open In Excel" should confirm if only one cell is selected

          If I run a query, forget to highlight all cells, then right click the results grid and choose Open In Excel then my right click will highlight a single cell, and the exported file contains only that one data value.

          I'm pretty sure 99.9% of the time this isn't what the developer wants..

          SOLUTION: if only one cell is selected, SQL prompt should ask "You only selected one cell, do you actually want the whole data grid or just that one cell? [Whole Grid] [One Cell]

          If it's a scalar query (only one cell result) then don't ask the question

          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 →
          • Tab History

            Tab history grows considerable with tabs that you don't care about. How about a hot key combination so that when the tab is closed it does not add it to history. Example: While holding the ctrl key down I close a tab and this prevents it from being added to history.

            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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
            • Rules around string literals as object identifiers are WRONG

              Per ANSI SQL, a string of characters enclosed in apostrophes (inverted commas) is a string literal, and a string of characters enclosed in double-quotes is a delimited object identifier.

              This means that the following is valid ANSI SQL:

              SELECT myColumn AS mc FROM dbo.MyTable;

              And the following is also valid ANSI SQL:

              SELECT "myColumn" AS "mc" FROM "dbo"."MyTable";

              But this is an ANSI catastrophe:

              SELECT myColumn AS 'mc' FROM dbo.MyTable;

              And the use of square brackets is just a weird MSSQL-only thing that should die a fast death.

              In SQL Prompt, Issue code DEP021 triggers when ANSI-compliant double-quotes are used…

              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  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
              • Code Navigation

                On large scripts it would be very handy to be able to navigate/jump between all occurrences of a variable.

                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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                • SQL AUTO-SYNTAX

                  when you insert a ssf (Select * from) you select the table and correct automatically errors like WEHRE, WERE, WEHER where the user wants to say a WHERE a logical word dictionary in which, it could be done by matching characters if all the characters written are 100% or 90% matches with word WHERE whenever is the order of the characters then autochange the text for where, This also can be matched with other KEYWORDS of SQL

                  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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                  • Extend Parsing power to SQL Queries and return referenced objects

                    Extend current Parsing to return (if requested) all SQL objects referenced by the object being parsed (including individual SQL queries passed as a string) in addition to the existing warnings/errors:
                    Fully referenced object (including linkedserver where used) with used columns or parameters and CRUD+E.
                    Call to the "Parser" via SSMS or command-line with independent result set for the referenced objects

                    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  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                    • STRING_AGG formatting the ORDER BY

                      When formatting SQL with a STRING_AGG which has a WITHIN GROUP (ORDER BY... the order by formats with extra spaces between the ORDER and the BY.

                      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 →
                      • formatting of OVER clause

                        Would like to control formatting of the OVER clause. E.g I would like the complete "(Partition by ... order by ...) as xyz" on one line, but today it's overrdden by other options.

                        3 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 →
                        • Spell check & Normalize variables, alias and column names

                          I, and I suspect many others, spend waaayyy too much time ensuring new column names, variables and aliases conform to a standard and are at least spelled correctly.

                          Recently I named a bunch of new table columns with the word "brokerred" in them. Whoops, the correct spelling is "brokered". I won't leave that mess in there and had to go back and clean up a bunch of code.

                          Also, include a list of allowed abbreviations. i.e. Qty for Quantity and flag when the full word is used instead of the abbreviations. Having both "QtyReleased" and "QuantityReleased" sprinkled around an application…

                          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 →
                          • Autoconnect Servers in Object Explorer.

                            A great feature would able to setup a list of serveres in SQL Prompt options.
                            And every time SSMS starts, it connects automatically to this list of serveres.
                            I spend a lot of time connecting to servers every morning, instead of them being there right away..

                            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 →
                            • MS_Description should be copyable in tooltip

                              Should be nice to be able to copy the MS_Description from the tooltip, since we store there explication for enum values and sometime formulas

                              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 →
                              • 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  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                • SQL Prompt -> Tab History -> add datetime stamp column

                                  Currently it shows the filename and servername, but it would really help to have the datetime of when it was executed. Sorting the columns would be an added benefit as well.

                                  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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Create boiler-plate stored procs for MS_Description maintenance and distribute to all SQL Prompt users.

                                    Create and distribute boiler-plate stored procs that can be deployed to *all* db owners using RedGate tools that can enable developers to better create and maintain MS_Description metadata on server objects. These stored procs should automatically abstract over existing system procs and *update or add* the MS_Description metadata. DB owners having these procs from a trusted partner like RedGate will enable them to better enforce the addition, maintenance, and usage of MS_Description metadata in SQL server databases. MS_Description is highly underutilized in industry, and this is a step to increase the utilization of said resource.

                                    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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Improve the "Open in Excel" context menu entry by preserving the data values

                                      Probably under the wrong category as I didn't see a related option for Excel, but bit values such as 1 and 0 should be preserved as such. Decimal values such as 12.000 should not have trailing zeroes truncated. And the most rage-inducing is NULL becoming an empty cell on a spreadsheet.

                                      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 →
                                      • DECIMAL default scale warning in Code Analysis

                                        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 )

                                        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 →
                                        • Intellisense filter

                                          When getting intellisense suggestions I often want to ignore suggestions from certain schemas and certain objects, just like the sys schema is ignored unless explicitly specified. These suggestions i want to ignore is based on either a fully qualified schema or a prefix of a schema or object name.

                                          It would be helpful to be able to specify a custom set of "hidden" objects that only shows if explicitly requested (by specifying the schema or full prefix).

                                          3 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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 42 43
                                          • Don't see your idea?

                                          Feedback and Knowledge Base