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. 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 →
    • Autocomplete WHERE clauses with variables

      It would be neat if WHERE clauses could get autocomplete suggestions with declared variables (or variables that are procedure parameters). Example:

      Assume Table1 with one column Column1.

      DECLARE @Column1
      SELECT *
      FROM Table1 T
      WHERE T.Column1 = (suggest @Column1, any variable that exactly matches column by name, except @)

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

        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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
        • Code Analysis Disable Rule for specific cases

          Hi,

          it would be extremely useful to allow the user to disable a code analysis rule for specific cases and not just on a global scope.

          E.g.
          cast(cast(0 as binary) pops up the issue BP008 (CAST/CONVERT to var types without length) which my be correct for certain cases but not always.

          It would be very hand if I could tell the analyzer to *not* give any warning for this single line, perhaps by adding a pseudo comment like --##BP008 or similar.

          This comment would temporarily disable the warning for this single line/case but not for the rest of a script.

          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

            5 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
          • Detect the database compatibility version

            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.

            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

              1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
            • Create package for Visual Studio Code

              Visual Studio Code has the ability to connect to SQL servers and execute scripts. It would be nice if SQL Prompt was available for Code as well.

              28 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

                6 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
              • Don't suggest join keys I've already used

                After I type
                SELECT * FROM sys.indexes i
                INNER JOIN sys.partitions p
                ON i.index_id = p.index_id
                AND

                the IntelliSense still suggests me i.index_id = p.index_id which I've already used. These duplicates can become pretty annoying when multiple columns are used for joining

                26 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 →
                • Discover metadata for OPENQUERY

                  When I use the OPENQUERY syntax to retrieve data across servers, SQL Prompt does not discover the metadata (column names, data types, etc.) of the fields returned.

                  My suggestion is that you add support within SQL Prompt to make metadata for fields retrieved by OPENQUERY available just like you do for linked servers.

                  5 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 →
                  • MS_Description supporting hyperlink when SQL Prompt is showing the tooltip

                    I'm currently working on a database with some really complex calculations which are saved then in a table. Putting these formula in the MS_Description is a pain as it cannot be shown correctly in the appearing tooltip text.
                    A nice Feature would be that I'm able to add a Hyperlink in the MS_Description which is pointing to the document in our SharePoint Server (or Wiki or whereever...).
                    Or - if this is not working, would it be possible to define a Special RedGate Attribute/Property (e.g. MS_DescriptionRedGate) below the MS_Description which is containing a hyperllink and this is then shown under…

                    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 →
                    • Use icon to denote fields with indexes

                      When the drop down appears with field names (like when you're typing in a WHERE clause), include a little icon for each field that's the first field in an index (like the key pic when it's the PK).

                      Being able to say "oh, that one has an index" would help me when trying to figure out how I want to filter things. (aka use "inserted_time" vs "post_time" vs the "start_time"). I'd say to use one icon (maybe greyed out) for non-clustered, and a different (or not greyed-out) icon for the clustered. You already include the field size, so why not…

                      14 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 →
                      • Autocomplete stored procedure With DEFAULT Values

                        When autocompleting a stored procedure statement in the format 'EXEC storedProc @param1 = 0, @param2 0' it would really help if the parameters would initially have the default values defined in the stored procedure (if applicable).

                        13 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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                        • Highlight Implicit Conversions due to Data Type mismatch

                          After spending some time refreshing my memory on implicit conversions, and the potentially disasterous affects on performance, the thought hit me...

                          Wouldn't it be great if SQL Prompt could hightlight potential implicit conversions when I write JOINS or WHERE statements?

                          I'm not sure how easy this would be to implement but I know everyone at Red Gate is very intelligent and highly creative so you'll find a way. :-)

                          37 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

                            3 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                          • when aggregating add alias

                            when doing simple aggregation such as sum(column), it would be nice if the column name would be aliased after the agg automatically. if this is a single column in the function then make the alias the column name. when multiple then create square brackets and move cursor into bracket after closing agg with a ")"

                            9 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

                              3 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                            • Pin feature for quick info

                              When the mouse pointer is hovered over a table or stored procedure etc, an intelli-sense like link is shown which can clicked to bring up the object definition, which disappears when something else is selected.

                              My suggestion would be a pin feature, so that we can keep the object definition quick info box visible on the screen for reference instead of it disappearing.

                              7 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

                                1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                              • Intellisense improvement : Write the FROM automatically for the user based on the SELECT

                                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
                                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 →
                                • Add an option to position SQL Prompt popup at a screen edge, rather than at the cursor position.

                                  What is near the cursor tends to be data that should not be covered over. I need to see it in order to complete my statement.

                                  10 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

                                    1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Load suggestions from sql files in Visual Studio/SSDT Projects

                                    Prompt currently needs a database connection to retrieve objects/suggestions from, which it gets from a database project's "Target Connection String".

                                    It would be better if prompt loaded suggestions directly from the sql files in the project without needing the database.

                                    68 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

                                      15 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →

                                      Thank you for your suggestion.

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

                                      Due to a lack of recent interest in this request, we are no longer actively reviewing it and have removed it’s “Under Review” status.

                                      If you feel strongly about having this feature added to Prompt, please continue to vote for and comment on this request.

                                      Kind Regards,
                                      The Prompt Team

                                    • Allow me to specify schemas to include or exclude

                                      The options to "Only load suggestions for certain databases" and "Don;t load suggestions for certain databases" are nice, but it'd be really useful to also be able to include or exclude on a per schema basis.

                                      34 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

                                        8 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Please include support for Extended Events in SQL Prompt

                                        Extended Events is a great feature in SQL Server. Without support for this in SQL Prompt makes it incomplete.
                                        I know we have a GUI for it in SQL Server 2012. But it will quite sometime before everybody is on the latest version of SQL Server

                                        11 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 →
                                        • Change quote completion behavior within Openquery or dynamic SQL strings

                                          I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
                                          So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.

                                          To illustrate the problem and my proposed…

                                          4 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
                                          • Don't see your idea?

                                          Feedback and Knowledge Base