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. string_agg is handled incorrectly

    The intellisense describes STRING_AGG as STRING_AGG(separator, expression), while it is the reverse: STRING_AGG(expression, separator). Also, when writing the GROUP BY and choosing "all non aggregated columns", the expression with STRING_AGG is added as well, which means SQL Prompt doesn't realize STRING_AGG is an aggregate function.

    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 →
    • Enhance INSERT Values formatting style

      On my project I have sql script files to automatically wipe and re-seed my database during development process. It works really great. It's basically about filling in master data tables. There could be tables with 200 lines for example. I have these scripts in Visual Studio under the source control of my project.

      I would like to have an INSERT Values formatting style where it will vertically align on commas separating values in a row. This way the data will look like a table.

      There is already a similar feature to format DDL STATEMENTS Schema definitions. For create table you…

      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 →
      • Code Analysis: Option to only enable for files, not for adhoc queries

        Sometimes we do things in adhoc queries that would violate Code Analysis rules, or we just do not want to make the effort to confirm to all the rules. Of course you can toggle Code Analysis with Ctrl+Shift+A, but it would be easier (and make it impossible to forget to switch it back on for "real code") if SQLPrompt had a setting of which the effect would be that Code Analysis only was enabled for query windows that were using a physical file, and not for ahoc queries that are not saved to a file.

        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  ·  Flag idea as inappropriate…  ·  Admin →
        • Formatting rules - add parenthesis around CASE statements.

          Please could you add an option to the CASE statements to automatically add parenthesis around the entire CASE statement.

          This is handy when you have a CASE statement and you can use the bracket matching highlight to see the end of the CASE statement.
          Our policy is to never have a CASE outside of parenthesis.

          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 →
          • 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 →
            • Please remove warning for WITH (NOLOCK)

              When writing a report query using WITH (NOLOCK) a warning is produced saying "TABLE HINT is used"
              It would be great to be able to configure that warning and turn it off.

              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 →
              • Move entire row(s) up/down in text editor

                How about the ability to move a single row or selected block of code up/down step-wise? Like Ctrl+Shift+Up arrow/Down arrow in Notepad++.

                I think this is rather essential functionality for all text editors, but for some reason MS seems to dislike the idea in their IDEs.

                (I know, in SSMS you can move a single row DOWN using Alt+Shift+T. But just being able to go in one direction feels kinda useless.)

                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 alias in update statements with sub selects

                  Support aliases when using in field chooser popup:

                  UPDATE GAging
                  SET CapAmt = (SELECT SUM(Amt) FROM GCappedClaim C
                  WHERE c.SiteName = A.SiteName)
                  FROM GAging A

                  The A.SiteName will not show a choice list.

                  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 →
                  • Qualify Object Names case correction works in SSMS but not Visual Studio

                    I am addressing the warnings for "Validate casing on identifiers". When I use Ctrl-Q Ctrl-B in SSMS, the objects are qualified and even casing is corrected on the object. However, when doing this same task in Visual Studio, object case correction is not performed. Please correct this.

                    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 →
                    • SC003 USE statement in batch

                      SC003 is highlighting and saying there is a problem that I have a USE statement in a batch. Um.....how in the heck do you propose to point a script to the appropriate database WITHOUT a USE statement. Last time I checked, the command to change database context was USE and anyone writing scripts and wanting to make sure they are run against the appropriate database will ALWAYS put a USE statement in a batch 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 →
                      • Always add column aliases

                        I prefer to always have column aliases in my code.

                        Like this:

                        SELECT
                        Column1 = Column1
                        Column2 = Column2
                        Column3 = CONCAT(Column1, ' - ', Column2)
                        FROM dbo.Table

                        Would be awesome if Prompt could always add aliases for me, so I woudn't have to add them myself

                        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 →
                        • Display UDT definitions

                          I'd like to be able to see the definition of a UDT that's referenced in code.

                          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 →
                          • Show popup even when error or warning exists

                            If I have a warning on a call to a sproc, say because I'm passing args without naming them, I can't hover over the sproc name and view script in order to see the arg names. Hovering doesn't bring up the poopup.

                            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 →
                            • New SCA rule: CATCH block should include THROW

                              It's far too easy for devs to make errors disappear in a CATCH block, so I would like to see a rule that forces the use of THROW in a CATCH block, preferably as the last statement so that unhandled errors are always bubbled up. Or at a minimum a rule that makes sure that the CATCH block is not empty.

                              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 →
                              • Inconsistently Advised to Use Alias For CTE (ST010)

                                Simple statements do not flag this:

                                WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable)
                                SELECT a.TestColumn FROM CTE1 a
                                INNER JOIN CTE1 b ON a.TestColumn = b.TestColumn;

                                However, more complex statements do:

                                WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable),
                                CTE2 AS (SELECT TestColumn FROM CTE1),
                                CTE3 AS (SELECT TestColumn FROM CTE2)
                                SELECT CTE3.TestColumn FROM CTE3
                                INNER JOIN CTE2 ON CTE3.TestColumn = CTE2.TestColumn;

                                In the final select clause, both CTE2 and CTE3 are flagged with 'Use alias for all table sources' (ST010).

                                Seems a bit OTT to suggest references to CTEs are aliased? I accept that a CTE defines, in relational terms,…

                                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 →
                                • Row-Level Security

                                  Enhance support for row-level security

                                  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  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Code Analysis EI028 Incorrectly Identified When Adding Not Null Column With Explicitly Defined Default Value

                                    Stop raising EI028 when adding columns using style:

                                    ALTER TABLE dbo.MyTable
                                    ADD TestColumnB CHAR(1) NOT NULL,
                                    CONSTRAINT DF_MyTable_TestColumnB DEFAULT ('B')
                                    FOR TestColumnB;

                                    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 →
                                    • Code Analysis conflicts with Intellisense

                                      Some code analysis rules conflict with the way IntelliSense is inserting code. That is frustrating. Example three and four part identifiers are deprecated. But I did not type those. They were inserted automatically.

                                      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 →
                                      • Give hint if the database name is written in a stored procedure or function.

                                        Some developers may write the database name inside stored procedures or functions. I recommend that SQL Prompt should give a hint of this.

                                        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 →
                                        • Use saved copy of Suggestions

                                          Have an option to use a saved copy of suggestions. There is one database I connect to that has a very large number of tables. When connecting the refresh sometimes times out. But the schema rarely changes so I could use the saved copy.

                                          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 →
                                          ← Previous 1 3 4 5 38 39
                                          • Don't see your idea?

                                          Feedback and Knowledge Base