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?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(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!

    55 votes
    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)
      You have left! (?) (thinking…)
      5 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

      9 votes
      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)
        You have left! (?) (thinking…)
        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…

        9 votes
        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)
          You have left! (?) (thinking…)
          0 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.

          7 votes
          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)
            You have left! (?) (thinking…)
            2 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.

            3 votes
            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)
              You have left! (?) (thinking…)
              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.

              3 votes
              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)
                You have left! (?) (thinking…)
                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
                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)
                  You have left! (?) (thinking…)
                  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
                  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)
                    You have left! (?) (thinking…)
                    0 comments  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
                  • Don't see your idea?

                  Feedback and Knowledge Base