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. 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 →
    • 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 →
      • Offer a pretty printed json view of json data.

        Json is not a native data type in Sql server. When you query a table with an xml column, the result to grid includes a hyperlink that allows you to open and view the entire xml in a formatted and colour coded window. I wish we had a similar function with any column where IS_JSON is true.

        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 →
        • Suggestion for "inserted JOIN deleted ON .."

          When suggesting conditions for a join between the inserted and deleted tables (in a trigger), SQL Prompt should suggest (as the first option) a join condition on the columns included in the primary key.

          For example, in a trigger on the Production.ProductCostHistory table in the AdventureWorks2014 database, if I'm typing "inserted i INNER JOIN deleted d ON" then SQL Prompt should suggest "i.ProductID = d.ProductID AND i.StartDate = d.StartDate".

          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 →
          • backup devices

            backup device

            I would like to see backup devices added to intellisence.

            Example

            If I key

            Backup database [name] to ....

            I would like to see a list of backup devices in intellisense drop down.

            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 →
            • Link server problem

              In sqlserver, if the link server is used, when the link server is not available, all databases are not intelligent.

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

                  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 →
                  • 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 →
                    • Language specific excpetions like recognize top(#) and not put "from" in brackets

                      well.. you learn something new every day... I just learned that top(#) is not ansi sql.. So is there a way to allow the language specific option of not having "from" getting automatically enclosed in brackets when it is typed after select top(#) *. I already have Enclose Identifiers off, and remove unnecessary brackets on.

                      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 →
                      • Intellisense selection should be consistent with visual studio - space bar

                        In VS when you use intellisense - you can use more than the enter key to select the suggested item in the drop down. You can use space bar for example - whereas sql prompt does not allow for this. You can also use various delimiting characters - like a parentheses or a period to complete the selection. Those don't seem to work in sql prompt - only the enter key works to select the suggested item.

                        This makes switching between Visual Studio and SSMS a little difficult. I have to do that all day long and I'm sure plenty…

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

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

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

                                    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

                                      5 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
                                        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 →
                                        • "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
                                            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 8
                                          • Don't see your idea?

                                          Feedback and Knowledge Base