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. Filter Tab History by Server name or Database Name

    It would be super useful to be able to filter the tab history modal by Server name, Database name or both.

    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
    • The group by option for all non-aggregate columns seems to get the columns from the select portion of the statement, including the function

      The group by option for all non-aggregate columns seems to get the columns from the select portion of the statement, including the function wrapping.

      I love this feature and would like have one additional context function called 'peel' or 'isolate' which removes all the function/formatting/whatever around a column and leaves the column.

      for example

      this:

      GROUP BY ISNULL(column1, '') ,
      ISNULL(column2, '') ,
      ISNULL(column3, '') ,
      ISNULL(column4, '0') ,
      ISNULL(column5, '') ,
      column6 ,
      column7

      becomes:

      GROUP BY column1 ,
      column2 ,
      column3 ,
      column4 ,
      column5 ,
      column6 ,
      column7

      Thanks,
      Erin

      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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
      • Keyboard shortcut for Unformat

        A keyboard shortcut for Unformat. I find that I format code with the SQL Prompt's "Format SQL" but there are always pieces of code that I want to unformat into a single line, and the keyboard would be faster than using the mouse to scroll and select the option (Or the Ctrl, U, down arrow, Enter keys).

        In fact the ability to assign keyboard shortcuts to the items in that list (have no idea what you call the dialog bubble menu) would be even better.

        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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
        • Combine styling and options

          Currently, you can have a style that can be shared across team members. There are still Options you must set that are not included in the style. It would be easier to share if the SQL Prompt - Options were included in the Style definition.

          Qualification is a good example and often a cause of t-SQL not performing as expected with subselects.

          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

            1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
          • Add support for localised English language variants

            I live in the UK. I use British English, not US English.

            Please support my locale and that of other English speaking users who are in the USA.

            Thanks!

            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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
            • Build an interface to update all Redgate Tools at once.

              I wanted to put this one level up (all Redgate), but did not see a way to do that.

              When you guys release an update, I do not see any choice but to open each tool, one at a time, and check to see if it was updated. There should be one interface that I can open that will check every product I have installed and install the appropriate updates. The current is much more time consuming than it should be and extremely inconvenient. If you have such a tool now, it should be easier to find.

              I thought Redgate…

              6 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
              • Output Into Highlighting Column and Value

                For example with this code:

                declare @MyTable table(Column1 varchar(20), Column2 varchar(20), Column3 varchar(20))
                declare @MyTableChanges table(Column1 varchar(20), Column2 varchar(20), Column3 varchar(20))

                insert into @MyTable (Column1, Column2, Column3)
                output Inserted.Column1, Inserted.Column2, Inserted.Column3
                into @MyTableChanges(Column1, Column2, Column3)
                VALUES ('Apple','Orange','Grape');

                select *
                from @MyTableChanges mtc

                Putting the cursor in one of the columns of the 'insert into' or 'values' clauses will highlight the corresponding column in the other clause. Putting the cursor in one of the columns of the 'output' or 'into' clauses does nothing special. It should also highlight the corresponding column in the other clause.

                This builds upon the already-implemented suggestion …

                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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                • Automatic tab renaming

                  Please add option to "Automatic tab renaming" which should automatically update tab name, based on written query.

                  3 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                  • Grid Mode with the same Description (Extended Property) as tooltips like the Column

                    It would be useful to display the original columns Description (Extended Property) when you hover over the Results column header, just like you do it with the Columns of a Table

                    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                    • Outline for scripts

                      It would be very helpful if there was an outline for the script being edited. Say, a script has many "CREATE PROC"s. We could have a tree or a list or a drop-down, to view a list of CREATE PROCs and click to scroll to the section.

                      If a tree style is selected, this could be expanded into seconds inside each PROCs.

                      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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • SQL Object quick navigation via keyboard shortcut & context menu

                        So a product called SqlSmash has this feature. It is a concept that exists in Visual Studio (or ReSharper) as well, which is the ability to quickly navigate via keyboard shortcuts to SQL objects (either by selecting them in object explorer or giving you the option to open them).

                        For instance, I could hit CTRL+. (or some other combination) which would bring up a context menu listing either the SQL objects for the current database/server, OR give me the option to switch server contexts. From the context menu I could filter the objects by typing, using the arrow keys to…

                        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

                          2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • grid 'friendly' view

                          it would be useful to have an option to quickly format the numbers in the resultgrid with commas and an optional number of decimal places. If i'm troubleshooting data with large numbers then I have to export each result set to excel and format the numbers manually each time so I can see what they are.

                          for example, if i have just a few rows/columns with numbers in the millions then having numbers formatted as

                          312,765,253 is easier to read than 312765253.12

                          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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                          • Object Explorer Remember Servers

                            SSMS currently has 2 different views for looking at servers. One is Registered Servers and the other is Object Explorer. Combining the two would lead to a much better experience. In tools like DataGrip and dbForge Studio, this is exactly what they do by default. You register the servers you're interested in up front and they show up every time you launch in what is the equivalent to Object Explorer. They even include the color coding to identify the server environment while browsing in the tree.

                            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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                            • Support multiple instances of SSMS to be open at the same time

                              I regularly have multiple instances of SSMS open with many scripts open in each. I often work on multiple servers or environments at the same time. Either running multiple scripts on each or working in one while keeping an eye on the output in another.

                              After a while SQL Prompt will crash SSMS when I do this.

                              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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                              • Open in Excel and the MRU

                                When Open in Excel is clicked in the grid right-click menu, the resulting workbook with a name like "Exported results 207-02-07_09-14-27.xlsx" is added to Recent Workbooks (File - Recent - Recent Workbooks) formerly known as the Most Recently Used list.

                                I would prefer if no entry was made to the list. If I want to save the results, I will rename the workbook.

                                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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                • Persist Keyboard shortcuts

                                  I like to bind Red-Gate shortcuts (RedGate.SQLPrompt.SSMSUI.Connect2011.ExecuteCurrentStatement for example) to make my life easier, but the bindings are lost each time that I restart SQL Server Management Studio (SSMS). Can the keyboard shortcut bindings be persisted on SSMS restart?

                                  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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                  • ”Visualize as” option in the context menu on cell in ResultGrid

                                    ”Visualize as” option in the context menu on cell in ResultGrid
                                    SSMSBoost has this feature (http://www.ssmsboost.com/Features/ssms-add-in-results-grid-visualizers-feature) and this is something I really miss in SqlPrompt. You should be able to easily add file types to choose among.

                                    Say as an example, Pdf is chosen on a varbinary cell. SqlPrompt saves the data to a temp file with the .pdf extension and opens the default pdf program.

                                    Very handy if you save generated pdf, images, html (send confirmation emails e.g.) etc etc in your database

                                    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Open in Excel - option to copy nulls as blank cells instead of empty string

                                      Please consider adding an option to bring over open in Excel null values as empty cells or instead of empty strings - excel considers empty string a 'value' in aggregate functions but ignores empty cells

                                      4 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Bookmarks

                                        Bookmarks is a feature of SSMS. But all my bookmarks are destroyed once the code is formatted. So, as SSMS' feature is not so good as I want I do suggest to implement this feature by RedGate.

                                        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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Results Information

                                          It would be great to see a log of the execution data for each tab (when executed/# of rows in result set/execution run time/etc). I would love to be able to be able to use that data for tracking/comparison as I'm working on a new script/making adjustments to old script/trying to optimize something.

                                          I would love to be able to answer questions like "Did my changes optimize the run time?", "Have my row counts been consistently the same?" without having to manually keep track of everything.

                                          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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5
                                          • Don't see your idea?

                                          Feedback and Knowledge Base