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. List aggregate functions before system fields

    When putting a COUNT in a select field, the default option in intellisense is sysxmitbody.count. I understand if I have a field that contains the aggregate name in my table that you suggest it first, but I never want sysxmitbody.count - and if I do, I'd expect to go looking for it.

    I feel like I've hit this problem with other aggregates as well, but can't find another example at the moment.

    Not sure the best fix, maybe list all system tables after user tables and functions?

    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 stored procedure using local time zone on datetime arguments.

      When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the *local time zone*.

      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 stored procedure using local time zone on datetime arguments.

        When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the *local time zone*.

        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 →
        • Control the behaviour of SQL Prompt insertion

          I would like the ability to control how SQL Prompt completes my statements for me, this mostly becomes an issue with procedures with multiple optional parameters.

          If I used sp_whoisactive as an example, there are multiple optional parameters but it is capable of running with no parameters at all, so I find myself having to spend longer than I want to either highlighting the bit I want execute or deleting all the parameters that just got written for me.

          So a setting where I can assign keys to complete full statement and keys to simply complete object name would be…

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

                  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

                    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 →
                    • 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).

                            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

                              2 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 →
                                • 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

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

                                        Thank you for your suggestion.

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

                                        We’re looking at adding more functionality to suggestions, in particular the ability to filter which schemas Prompt gives suggestions for.

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

                                        Kind Regards,
                                        The Prompt Team

                                      • 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