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. Dockable Summarize Script window that allows select/run of script blocks.

    Summarize script is sort-of useful as a way to see script blocks easily, but it will be BRILLIANT if it was a dockable (not modal) window that you very quickly select the script blocks in the editor.

    I often select parts of a script or subqueries to run - if Summarize Script automatically selected them for me it would be a huge productivity boost: 1-click selection + F5 = AWESOME!

    23 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

      5 comments  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
    • Summarize Script by Comments

      Allow an option in Summarize script to show summary by comments (for those of us that do a reasonable job of commenting code)! That would be more useful to a developer unfamiliar with specific complex code.

      5 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

        2 comments  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
      • Add an option to Summarize script to show not only the main table, but also all other joined tables

        Add an option to Summarize script feature to show not only the main table, but also all other joined tables

        For example with option off (current release)

        select from tablea
        update tableb
        delete from tablec

        Turning option on would result in

        select from tablea
        join tablex
        update tableb
        join tablex, tablec, tablej
        delete from tablec
        join tableb

        5 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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
        • Keep selection when closing the "Summarize Script" window

          The "Summarize Script" feature is great and helped me many times to navigate large scripts. I like especially the fact that the code is highlighted when I click on different parts of the summary. Unfortunately, the selection vanishes the minute I close the summary window. I don’t know why that is.

          Of course the new feature of highlighting matching BEGIN … END helps me find the beginning. Yet, I don’t see the reason why the selection is not longer available after closing the summary window.

          Furthermore, I would like to suggest that – in the summary window – you allow…

          5 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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
          • Show SELECT INTO within the Summarize Script pane

            Within the Summarize Script pane, it would be helpful to differentiate between a SELECT statement (which returns output to the user) and a SELECT INTO statement (which creates a table and loads data into it).

            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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
            • Enhance hover-over pane for a Table Variable to show PRIMARY KEY

              When hovering over a Table Variable, it is handy to show the column definitions, but when a PRIMARY KEY has been included in the DECLARE, there's no sign of it.

              Only found this when an unexpected PK Violation occurred in a very long SP.

              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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
              • Include any referenced object in Summarize Script

                At the moment we have basic SELECT statement handling in Summarize Script, only showing whether it is a SELECT FROM <table> or SELECT <expression>.

                So a query such as

                USE [AdventureWorks2014]
                GO
                select
                (select top 1 emailaddress from Person.EmailAddress),
                dbo.ufnGetPurchaseOrderStatusText(1)
                from Person.Person

                Would only show

                SELECT from Person.Person

                Would be useful to also show any tables referenced in a subquery, and also UDFs.

                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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
                • in "summarize script", an "if" and its "else" should be on the same level

                  This statement:

                  IF condition
                  ...
                  ELSE
                  ...

                  is semantically equivalent to this pair of statements:

                  IF condition
                  ...
                  IF NOT condition
                  ...

                  That's how I think of them. SSMS and SQL Prompt treat them that way; If I use SQL Prompt to format my SQL, and SSMS's "outline statements" feature to collapse regions of code, then an IF/ELSE statement looks like this:

                  IF @I = 1
                  [+] BEGIN [...];
                  ELSE
                  [+] BEGIN [...];

                  The IF block and the ELSE block are treated as two separate IF statements with equal importance. The ELSE keyword lines up with the IF keyword, and…

                  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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
                  • Don't see your idea?

                  Feedback and Knowledge Base