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 vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  1. Add support for SQL CMD variables in SSDT/VisualStudio

    When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.

    SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
    Then a becomes an "unresolved alias"

    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 →
    • When typing after selecting an object the source popup appears. Shortcut key to the copy button

      Often when working on a database object will type exec procname/select * from view/table. When the desired object is selected with arrow keys a Sourcebox popup appears with a Copy button. A shortcut key to this button would be fantastic. Fingers on keyboard instead of finding mouse.

      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  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
      • Surround list of values with quotation marks and separate by commas

        when creating a WHERE colname IN ('a','b','c')

        it would be nice if you could paste a set of rows from excel into SSMS and then add the quotation marks and commas

        i.e.

        A
        B
        C

        becomes

        'A',
        'B',
        'C'

        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 →
        • Inserting the AS keyword for aliases

          It would be nice if one could click a button and get the AS keyword between an object name and its alias. This would help with code that doesn't use AS to separate the two. And would also help readability.

          Thanks.

          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…)
            0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
          • increase a list of description fields in the quick preview list instructions?

            Database for the field description and explanation, can increase a list of fields in the quick preview list instructions?

            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 →
            • Shortcut for Switching Styles

              Can you add "choose style" or "switch style" to the commands section, as a drop down, so that it can be added to the SQL PROMPT toolbar? Or possibly as a hot key menu option?

              I switch styles often. There's the style I like to work in, a style suited for debugging, and the style that management likes the code to be posted with (in TFS.) Being able to switch between them is very helpful. but, going to SQL Prompt --> Options --> Styles --> Selecting Style "with the mouse" is time consuming.

              Thanks for your consideration!

              Lawrence Barnes

              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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
              • "d" in "order by" should prompt with "desc", not "dbcc"

                Currently if you type a query like this:

                select *
                from sys.objects o
                order by o.name d[CURSOR]

                the popup consists of dbcc, deallocate, declare, delete, deny, desc, disable trigger, drop, dump.

                While that is probably technically accurate, it would be much more helpful to make "desc" the first entry in the list, because it's what I'm typing 100% of the time.

                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 option to include tab before commas that start new lines (Format SQL)

                  Under Options > Format > Commas & parentheses: there is an option to "place commas at start" and then choose your alignment.

                  When aligning to the statement (at least), there should be an option to include a tab or space before the comma.

                  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 →
                  • Display column/table description in tooltip

                    This would greatly enhance the tooltip when dealing with tables with vague column names or special instructions.

                    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…)
                      1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                    • Remove extra space between statements option is Needed

                      SELECT
                      *
                      FROM
                      Temp1

                      --Remove this kind of extra spacing between statements option is Needed

                      SELECT
                      *
                      FROM
                      Temp2

                      --Remove this kind of extra spacing between statements option is Needed

                      SELECT
                      *
                      FROM
                      Temp3

                      26 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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                      • Requested change in SQL Prompt formatting.

                        Requested change in SQL Prompt formatting.

                        I'd like to get the formatting options for stored procedure parameters enhanced. Right now the formatter insists that the right way to do it is:

                        EXECUTE RTPOne.dbo.proc_reportRetailInventorySales @BeginTransactionDate, @EndTransactionDate, @LocationCode, @ProductGroupCode,
                        @ProductCategoryCode, @VendorID, @ColorCode, @SizeCode, @size_category_Code, @S_ShowInActiveInd, @RetailSeasonCode, @SessionToken;

                        with or without wrapping.

                        I'd like the option to make it look like:

                        EXECUTE RTPOne.dbo.proc_reportRetailInventorySales
                        @BeginTransactionDate
                        , @EndTransactionDate
                        , @LocationCode
                        , @ProductGroupCode
                        , @ProductCategoryCode
                        , @VendorID
                        , @ColorCode
                        , @SizeCode
                        , @size_category_Code
                        , @S_ShowInActiveInd
                        , @RetailSeasonCode
                        , @SessionToken;

                        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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                        • multiple selections on column picker for join criteria

                          allow multiple selections on join conditions in the intellisense like you do when you selecting (column picker)

                          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…)
                            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                          • Updates: one for all and all for one

                            Would be nice that when checking updates for one application, say SQLPrompt (the most common), all available updates would be checked for and installed too.

                            It's not the most effective to only update the app you are opening within a suite (or all installed Red-Gate products if not on a bundle). The whole suite's updates should be available.

                            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 →
                            • Apply current SQL Prompt settings to all existent stored procedures.

                              We could apply the current settings to all the existent stored procedures in one database. If we make any change to these settings, then having the way to apply this setting to all the stored procedures.

                              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…)
                                2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Highlight a SELECT stmt and create a temp table definition from it.

                                Highlight a SELECT stmt and create a temp table definition from it. You often need to create #tables and you have a select to fill it with. However, you have to either create the #table manually or do a SELECT INTO into a real table and then script it out. It would be nice to be able to just take my SELECT and be able to get the #table definition for it.

                                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…)
                                  1 comment  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
                                • Tab Groups

                                  Add the ability to define groups of tabs that are used regularly for different jobs. For instance--there is a group of scripts I use for month end processing and a completely different set of scripts I typically have open for daily processing. Monthly statement preparation and troubleshooting comprise another set of scripts. I'd like to be able to name groups of tabs and retrieve them based on that named grouping, while still being able to go back to what I was doing before the "interruption" that caused me to need a different set of tabs open.

                                  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  ·  SQL Tab Magic  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Configurably include table hints when auto-completing a table

                                    For a specific database/server, automatically append configurable table hints (or free text) such as with(nolock) to any table name that is auto-completed.

                                    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  ·  Qualify Object Names  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Remove Red Gate toolbar

                                      This is an old problem that just won't go away.

                                      The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.

                                      Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.

                                      Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).

                                      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…)
                                        1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                      • highlight all columns and filters for a table alias when that alias is selected

                                        when selecting a particular table alias, can you highlight all places where that alias is being used like in notepad++

                                        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 →
                                        • highlight column name and copy to clipboard with one mouse click

                                          often need to copy names and have to double click,use control + c to copy it to the clipboard. Can you make this process simpler by offering a shortcut key. For example holding the control key in when clicking will highlight and copy the text to the clipboard. All you would need to do then is click the cursor where you want the work and it pastes it there. This would make aliasing aggregations very quick

                                          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 →
                                          ← Previous 1 3 4 5 18 19
                                          • Don't see your idea?

                                          Feedback and Knowledge Base