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

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

              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…)
                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?

                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…)
                  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 →
                  • 32 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 →
                    • dynamic sql match parameters def, parameter values and statement parameter usage

                      When I use sp_executesql, the parameters definition, parameter and the usage in the dynamic sql are not checked until execution time
                      It would be great if you could analyze the param list and check that the there is a match of param type, number of params.
                      Also if you can match the three when selecting a param as you match with insert columns and their values

                      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 →
                      • Defer tab connection until it is opened

                        I tend to have lots and lots of tabs open, both in SSMS and my browsers. Firefox has a very good option to only load a tab once I click it.

                        Would be great if SQL Prompt would do the same, waiting for it to restore connections for 20+ tabs is quite frustrating when you are in a hurry.

                        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…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add OUTPUT parameters when executing a stored procedure

                          When inserting code to execute a stored procedure, SQL Prompt currently automatically generates input variables of the correct data type, e.g.:

                          EXECUTE ETL.spLoad_DimPerson
                          @LatestLoadDate = '2016-06-21 18:51:43', -- datetime2
                          @TargetRowsInserted = 0, -- int
                          @TargetRowsUpdated = 0, -- int
                          @TargetRowsDeleted = 0 -- int

                          However, the syntax does not seem to recognize OUTPUT parameters. When I ask SSMS to generate a query for me by right-clicking and choosing 'Execute stored procedure...', it gives me the following:

                          DECLARE @return_value int,
                          @TargetRowsInserted int,
                          @TargetRowsUpdated int,
                          @TargetRowsDeleted int

                          EXEC @return_value = [ETL].[spLoad_DimPerson]
                          @LatestLoadDate = '2005-06-21 18:41:59',
                          @TargetRowsInserted = @TargetRowsInserted OUTPUT,
                          @TargetRowsUpdated = @TargetRowsUpdated…

                          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…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • prevent undocumented keywords from coming up as aliases

                            Right now SQL Prompt will avoid auto-generating a keyword as an alias, such as in the following example:

                            DECLARE @AlphabetSoup TABLE (x INT)
                            SELECT * FROM @AlphabetSoup aso -- extra "o" to avoid "as"

                            However, I've run into a couple of undocumented "keywords" that SQL Prompt doesn't exclude:

                            DECLARE @AlphabetSoup TABLE (x INT)
                            DECLARE @ReasonableColumn TABLE (y INT)
                            DECLARE @RidiculousColumn TABLE (z INT)
                            SELECT * FROM @AlphabetSoup aso CROSS JOIN @ReasonableColumn rc CROSS JOIN @RidiculousColumn rc2

                            For whatever reason, rc2 (along with rc4, see http://dba.stackexchange.com/questions/22655/why-is-lookup-colored-as-a-function-reserved-word-in-sql-server/22661) is coming up as a reserved keyword. Can SQL Prompt avoid generating this as…

                            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 →
                            • sp_configure to make suggestions similar to serverproperty

                              When writing queries that run "sp_configure", it would be helpful if the various configuration options were offered in a dropdown - much the same way that happens when writing a "select serverproperty" query.

                              For bonus points - highlight the state of Show Advanced Options at the top of the list, so we can see what's currently available vs what could be available.

                              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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                              • Create Declare and Set Statements

                                Many tmes I'll paste a SQL statement from a stored proc into a script so I can manually run the query to see the results.

                                It'd be nice if there was an option from SQL prompt to scan the SQL and find the parameters used in the query and add DECLARE and SET statements at the top,

                                It could evaluate where the parameters are being used and determine their datatype for the DECLARE and some default value in the SET statements.

                                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…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • change connect of tab

                                  I dont know if its possible, but it would be awesome if you could right click on a tab and change the connection on the fly. I have used this feature in other IDE and its helpful when query between TEST and Prod without having to re-connect.

                                  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 →
                                  • Improve the new rename variable feature

                                    Instead of having to select the "rename variable/alias" in the context menu, how about auto-detecting that a variable has been changed and prompt the user or flag the user for some input to update all usages of the variable. I envision this happening when changing the variable name at the DECLARE statement. Perhaps a shortcut key would force the rename as well. I think in VS when a variable is changed, it flags it and wait for the user to give some sort of queue for it to rename all instances of the variable with the new name.

                                    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 →
                                    • Ability to call "find invalid objects" from T-SQL

                                      Our organization would like to have a report of invalid database objects. SQL prompt has this functionality built in but I'd like to call this feature from T-SQL and display the results on a report.

                                      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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Ability to generate SELECT test script from an UPDATE statement

                                        When debugging an UPDATE statement, it would be handy if SQL Prompt could generate a test Select script that converts

                                        UPDATE xxxxxx
                                        SET SalesPeriod = dddddd,
                                        SalesYear = yyyy,
                                        CustomerCode = zzzzz
                                        ...

                                        into

                                        SELECT dddddd as SalesPeriod,
                                        yyyy as SalesYear,
                                        zzzzz as CustomerCode
                                        ....

                                        Optionally, could include all columns involved in joins or WHERE clauses

                                        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…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • multiple "Workspace"

                                          Allow the current tabs to be saved (and then reloaded). Having multiple Workspaces like this would be of great benefi

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

                                          Feedback and Knowledge Base