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. 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 →
    • FORMATMESSAGE with automatic message IDs

      If we are typing a FORMATMESSAGE or a RAISERROR and our messages are precodified with numbers, it would be nice to get a list for messages with an small listbox to search the message by some text and get the number of the message with a comment inserted into the prior line.

      Before:

      SET @msg=FORMATMESSAGE(N'excee',....

      After search by the word "%excee%" and with an intelissense combobox... we get:

      --IDMsg 02938:"%s - ERROR: Limit exceeded for %s"
      SET @Msg=FORMATMESSAGE(02938,N'velocity');

      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 @)

        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 →
        • Add support for CONNECTIONPROPERTY and other missing system functions

          Some system functions are not suggested by SQL Prompt (9.2.8.6358), at least while connected to a SQL Server 2016 server: CONNECTIONPROPERTY, CURRENT_REQUEST_ID, CURRENT_TRANSACTION_ID, ORIGINAL_DB_NAME.

          The CONNECTIONPROPERTY function would be especially useful, given that it has some parameters that could be filled-in by SQL Prompt (similar to the OBJECTPROPERTY 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 →
          • dbcc clonedatabase intellisense should include the WITH SERVICEBROKER option

            Intellisense for CLONEDATABASE does not include the SERVICEBROKER option added in 2016 SP2

            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 →
            • Option NOT to ignore underscore in Suggestions

              Currently if you type "abcd" both "ab_cd" and "a_bcd" (and any similar derivative containing underscore) will appear in suggestion list.

              I understand this itself was created as a response to a user request here but for this user it creates an inconvenience.

              I suggest having an option called "Exact match" or "Do not ignore underscore". When this checked only exact matches will appear in Suggestions list. That is when "abcd" is typed only items containing "abcd" will appear.

              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 Navigation

                On large scripts it would be very handy to be able to navigate/jump between all occurrences of a variable.

                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

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

                        1 comment  ·  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.

                        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

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

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

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

                                          Feedback and Knowledge Base