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 http://www.red-gate.com/messageboard/viewforum.php?f=169.

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. EI003 incorrectly fires for ANY or AND

    EI003 incorrectly identifies the ANY and ALL clauses

    Select test
    from table1 where id = ANY(select linkedId from table2)

    have squiggle under the (select linkedid from table2)

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
    • Suggest Primary Keys first for join option

      When joining two tables that don't have a foreign key relation, SQL Prompt suggests all columns that exist in both tables (e.g. table1.col = table2.col). If one of those fields name is a primary key (e.g. if table1.col and/or table2.col are primary keys on their respective tables) then list that as the first suggestion.

      2 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
      • LOGINPROPERTY

        The LOGINPROPERTY function is not listed in Intellisense like DATABASEPROPERTYEX and SERVERPROPERTY. And since it is not listed, the applicable properties are not provided either.

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
        • Remove keywords from Intellisense suggestions

          it would be nice, if we could edit the list of suggested keywords and remove stuff like PROC (as shortcut for PROCEDURE) or INFORMATION_SCHEMA (which I only used once in some copy-paste-code, since it is outdated).

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
          • Don't display fx Log() at top of field list

            Don't display fx Log() at top of field list when my field is [Log_ID], etc, as I type. It would be so rare that I would use Log()

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
            • code analysis blocks object detail

              SQL Prompt v9.0.2.3223 use of Code Analysis has stopped the tooltip for showing structural details.

              ie: statement like SELECT a,b,c FROM dbo.TableRequiringLock WITH (ROWLOCK, XLOCK) WHERE ID = @key

              will just show TABLE HINT used when hovering over table name as opposed to showing the structure.

              2 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                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.

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                • CTE Auto-Alias

                  Enable Auto-Aliasing when referencing an expression within the CTE syntax from an outer query. For example, let's say you have the following CTE:

                  ;WITH my_cte AS
                  (
                  SELECT Column1
                  , Column2
                  FROM MyTable
                  )
                  SELECT *
                  FROM my_cte AS mc

                  SqlPrompt would automatically alias "my_cte" when being referenced in the outer query according to the set auto-alias rules. Today, SqlPrompt adds the CTE name to the list of suggestions in intellisense, it just does not auto alias. Most often times I join CTE expressions back to other tables in the outer select. Today I have to manually alias the CTE…

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                  • Code Analysis config to flat file

                    Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I _know_ not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.

                    Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway…

                    7 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      3 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 allow people to share setting and collaborate when using Prompt Code Analysis.

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

                      Kind Regards,
                      Prompt Team

                    • 1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                      • "Dependencies" tab in the information popup for DB objects other than columns.

                        Clicking the Hover hyperlink for a column will produce a Dependencies tab (awesome, BTW). The Hover Hyperlink for (most) other objects will give Script and Summary tabs (also awesome). What would make it even more awesomer would be to produce a Dependencies tab for these other objects as well.

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                        • Suggest main statement aliases inside APPLY clause

                          when inside an APPLY statement, the aliases from the outer query should be available for adding to the WHERE clause inside the APPLY.

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                          • Option to disable Tab key from popping up suggestions

                            I would like an option that can disable the tab key from popping up the suggestions menu/popup. When I am formatting my code in SSMS using the tab key to line up various items, each time I hit tab, the suggestions menu pops up.

                            MOST of the time this isn't an issue other than ignoring the pop-up. Occasionally, based on what is in the code I am formatting, when I hit tab it will auto select an item in the suggestions, and the second tab will insert the suggestion. This slows me down quite a bit.

                            In the mean time,…

                            1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add option to default time to either UTC or local when expanding parameter lists.

                              I would like to see an option to default times to either UTC or local time when expanding stored procedure parameter lists. Many larger companies are distributed across time zones and use UTC rather than local time but the vastly more numerous smaller organizations operating in a single location, generally use local time. Having to manually edit all the times in a parameter list somewhat limits the value of default values.

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 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.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                • Joining tables from other database tables does not include database name prefix with suggested join tables

                                  I created a query that joins tables from another database (dbname..tablename) and had to join another table from that database.
                                  The table I wanted to use came up as a suggestion because of the relation between those two tables. So I selected the table, but the databasename prefix wasn't added. That was a bit unfortunate

                                  2 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                  • disable the column picker for IN clauses

                                    Give us the ability to disable the column picker for an IN clause, so that when you're trying to say "IN (3,4,5)", it doesn't keep popping up suggestions for a field.

                                    4 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                    • If the database settings password is empty, then the smart prompt does not come

                                      If the database settings password is empty, then the smart prompt does not come

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Include column picker for where clause and allow entering of variables/values

                                        When you type the WHERE clause, allow the user to choose from the column picker with textboxes on the right to allow the user to input the values.

                                        e.g.
                                        [ ] ID Value [_____________]
                                        [ ] Name Value [_____________]
                                        [ ] Surname Value [_____________]
                                        [ ] ID Number Value [_____________]
                                        [ ] Cellphone Number Value [_____________]

                                        0 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Suggest correlated subquery "join" criteria

                                          When doing a correlated subquery, like:

                                          SELECT
                                          FROM Table1
                                          WHERE NOT EXISTS (SELECT *
                                          FROM TABLE2
                                          WHERE <--- pop up here

                                          Do the same matching as if we had written:

                                          SELECT
                                          FROM Table1
                                          JOIN TABLE2
                                          ON <--- pop up here

                                          3 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            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 6 7
                                          • Don't see your idea?

                                          Feedback and Knowledge Base