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. Synchronize Object Explorer with the current query window

    Have the object explorer automatically open and synced to the currently connected server/database for the query window. This removes the "disconnected feel" that SSMS gives with query windows and object explorer connections be out of sync.

    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
    • Ctrl+z Not working when a wrong template was generated

      When I am trying to use the SSF template and by mistake, i would type CSF then Ctrl+z does not work. it would be nice if we can have this option

      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  ·  Flag idea as inappropriate…  ·  Admin →
      • Show default constraints with value/formel on summary tab

        It would nice to see the default value for a column within the summary tab in the mouse over for a table

        Regards
        Robert

        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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
        • decimal

          Hi, It would be great, if you add precision and scale on numeric/decimal data types - column hint and table summary.

          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…)
            planned  ·  1 comment  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
          • Allow Format SQL to execute even when there are errors

            If I'm halfway through writing a query and I want SQL prompt to format it in order to make it easier to finish what I'm doing, SQL prompt currently will fail because the query's not syntactically correct.

            What I'd like is an option where I can tell SQL prompt I don't care if the queries I'm formatting are incorrect, just do your best with it and ignore any errors.

            5 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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
            • tSQLt / SQL Test spyProcedure suggestions

              It would help a lot if SQL Prompt shows suggestion for spied objects and their columns.

              If a developer starts typing dbo.ProcedureToSpy_sp... SQL Prompt should suggest dbo.ProcedureToSpy_spyProcedureLog.
              For SELECT * from dbo.ProcedureToSpy_spyProcedureLog SQL Prompt should be to resolve the star to the parameter of the spied object.

              Example
              CREATE PROCEDURE TestClass.[test ProcedureToTest_MoreInformationAboutTheTest]
              AS
              BEGIN
              --Assemble
              BEGIN
              EXEC tSQLt.SpyProcedure
              @ProcedureName = N'dbo.ProcedureToSpy',
              @CommandToExecute = NULL;

              DECLARE @Actual int,
              @Expected int = 1;
              END;

              --Act
              BEGIN
              EXEC @ReturnCode = dbo.ProcedureToTest;
              END;

              --Assert
              BEGIN
              SELECT @Actual = ParameterA /*enable column suggestions here*/
              FROM dbo.ProcedureToSpy_spyProcedureLog /*enable object suggestions here*/;

              EXEC tSQLt.AssertEquals
              @Expected = @Expected, …

              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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
              • Add the ability to selectively disable the "UPDATE without WHERE" warning

                I like the idea of the UPDATE without WHERE warning - there has been a couple of disastrous times where I've missed out a WHERE and updated the wrong data.

                However, SQL Prompts "one size fits all" option of on or off makes the feature useless. For example, I have multiple scripts that do UPDATES to clear out personal information from various tables, which I use when taking copies of customer databases for support purposes, be that hunting down a bug, or performance profiling.

                Resharper lets your selectively disabled it's multitude of rules by adding comments in the source code,…

                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…)
                  1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                • Option to Sort Columns by Column Order or Column Name

                  Currently in Select Statements by Column Order
                  While in Where Statements by Column Name
                  which is confusing , I prefer by Column Order anywhere in my query.

                  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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                  • End column guide lines

                    I think SSMSBoost has this feature: being able to add configurable guide lines to limit the query writing space to a specified number of characters/columns. This is very handy as I always want to keep my code narrow, within the 80-char limit. Currently, I have to install SSMSBoost for it... Could this please be added to SQL Prompt? This is probably a quick feature to implement and would be tremendously useful. Thanks.

                    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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                    • About how to implement query formatting...

                      Hi there. I've seen how DevArt implement SQL formatting in their product, SQL Complete, and must say I think this IS the way it should be done. Here's a link to a YT vid that brings out the capabilities of the product: https://www.youtube.com/watch?v=LRKQXDXS5JU&list=PLpO6-HKL9JxXSZgO3L0MxOTt3QxpFbJNt&index=5
                      Could such formatting options be implemented in SQL Prompt, please?

                      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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                      • Collapsible fields in SELECT, UPDATE and INSERT

                        When working with data warehouses one has to often write queries against tables with many, many columns. The best practice tells us to always exactly specify the columns one wants in the SELECT query. Problem is that there are so many columns to write out that scrolling becomes excessive and tedious. I've been wondering... Could SQLPrompt somehow turn the stuff between SELECT and FROM collapsible with little effort on part of the dev? A keyboard shortcut would be perfect. This could also work for, say, UPDATE between SET and FROM. What about collapsible field in INSERT? I always write out…

                        0 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  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
                        • Ability to toggle the export behavior of NULL values when using 'Open in Excel'

                          SQL Prompt 7.2 introduced the export of NULL values as an empty string when using 'Open in Excel'.

                          I'd like to see an option added to toggle the behavior this feature, there are some cases where I would want 'Open in Excel' to export 'NULL' instead of an empty string.

                          4 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  ·  Flag idea as inappropriate…  ·  Admin →
                          • TAB HISTORY Restore Multiple Closed Tabs

                            Add a checkbox next to each closed tab history item, all multiple selection. Default should be unchecked. Easier way to recover a session of multiple tabs when session runs out of memory and a re-open of SSMS doesn't restore any or all tabs.

                            5 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                            • Export Multiple Grids to Excel

                              Consider allowing export of multiple grids or just selected grid to excel. If multiple grids they would each go to a new worksheet.

                              This behavior is what SSMS Boost allows and would be great to include in SQL Prompt

                              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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                              • Integrate search feature into Object Explorer

                                For now we have that feature, but it is really crazy. I could not image a case when I want to find the 'Synonyms" folder. It would be nice to have an ability to search for an object right in the Object Explorer. There are many details, I know...

                                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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                • Warning when INSERT statement exceeds limit of row value expressions

                                  The INSERT statement syntax allows for INSERT statements of the format:

                                  INSERT INTO <<tablename>> (col1, col2) VALUES
                                  (v1, v2), (v3, v4), (v5, v6)...

                                  And this is well supported by SQLPrompt. However, there are limits within SQL Server about the number of these "row value expressions" (eg "(v1,v2)" in the code snippet above) that can be used in a single INSERT statement. If that limit is exceeded, the statement still looks like valid T-SQL, and is still treated as such by SQLPrompt & SSMS, but SQL Server itself throws an error when it gets the statement:

                                  Msg 10738, Level 15, State…

                                  6 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…)
                                    1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Extract parameters from sp/fn invocation

                                    Often I write something like exec myDevelopingSP @UserID = 1, @Filter = '1;2;3;4'.... and so no. I'd like to have an ability to declare my params in a single click. Just you guys already know the param list and have parsed my script.

                                    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  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Store cache for some database

                                      I connect to Client SQL server on my local machine through VPN.

                                      It would be very helpful to store structure cache of pre-defined database.

                                      This would not require to load data every time I connect to same server.

                                      11 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…)
                                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Multiple rows of tabs

                                        If I have more open tabs than can horizontally fit the window SSMS does not show all of them but instead there is a dropdown in the right upper corner. I would prefer if I could have multiple rows of tabs instead, like in VS. Since it does not seem likely that MS is going to implement that soon, can it be done in SQL prompt?

                                        15 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Export and/or Print output from Summarize Script pane

                                          Currently, the Summarize Script is great as an interactive thing, but it could do with the option to export the view to a graphic or a document for those who need to look at particularly large scripts (or who want / need to scribble over things with a red pen...)

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

                                          Feedback and Knowledge Base