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

    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 →
    • 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++

      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  ·  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 →
        • when aggregating add alias

          when doing simple aggregation such as sum(column), it would be nice if the column name would be aliased after the agg automatically. if this is a single column in the function then make the alias the column name. when multiple then create square brackets and move cursor into bracket after closing agg with a ")"

          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 →
          • Select current statement/block

            I have become very accustomed to using "Execute Current Statement or Block" [1]. As I copy SQL from script to script, I would find the ability to *select* the current statement very useful, too.

            1 - https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/3722890-execute-current-statement-block

            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 →
            • Different snippets with the same trigger

              Hi,

              SQL Prompt does not support different snippets with the same trigger string.

              What I want is:
              Let's say I have created two snippets:
              1. CREATE TABLE .....
              2. CREATE DATABASE ....

              and both of them use "create" to trigger the snippet insertion. When I type "create" and press "tab" button, since this matches two snippets, a selection is prompt to the user, and let's say the user selected "CREATE DATABASE ...", so the corresponding text will be inserted.

              Please consider this feature and I think it will be very useful. In some way it's like the method overloading in…

              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  ·  Flag idea as inappropriate…  ·  Admin →
              • Add a number before each suggested items

                Is it possible to add a number before each suggested item in the popup?
                Like the snapshot below:
                http://i.imgur.com/untMjQ9.png

                We can only add numbers for the first 10 items (corresponding to 1, 2, 3, 4, 5, 6, 7, 8, 9, 0) if the total number if items is greater than 10.

                That way we can can press the corresponding number to select that item and we don't need to use mouse or move hand and press arrow keys.

                I think this should be useful.

                Thanks.

                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 'N' to unicode type literal strings

                  Hi,

                  Is it possible to format below code

                  DECLARE @a VARCHAR(200);
                  SELECT @a = 'asdf';
                  DECLARE @b NVARCHAR(200);
                  SELECT @b = 'asdf';

                  to

                  DECLARE @a VARCHAR(200);
                  SELECT @a = 'asdf';
                  DECLARE @b NVARCHAR(200);
                  SELECT @b = N'asdf';

                  Thanks.

                  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 →
                  • external remark/description to a suggested column

                    Is it possible to add user specific additional tooltip text to a highlighted column/table line during the suggestion? We could create a special table which includes tooltip text with the key table name + column name. If you navigate through the suggested field list the tooltip appears and disappears if it exist or not.

                    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 →
                    • Query Tab naming

                      You could create a way that we can put a 'description' on the top of the script we are typing on the query window, so that when we move the mouse up to the tab title for unsaved scripts, a hint with this description will be shown instead of the defultt SSMS hit 'SQLSqueryX.sql - server.database.....'

                      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  ·  SQL Tab Magic  ·  Flag idea as inappropriate…  ·  Admin →
                      • Auto complete/intellisense suggestions using PIVOT

                        Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.

                        The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)

                        Ex:[code]CREATE TABLE dbo.tbTest(
                        Id INT,
                        foo VARCHAR(3),
                        bar FLOAT
                        )
                        GO
                        INSERT INTO dbo.tbTest
                        VALUES (1, 'foo', 2)
                        , (2, 'bar', 3)
                        , (3, 'foo', 4)
                        GO
                        SELECT *
                        FROM (
                        SELECT *
                        FROM dbo.tbTest AS tt
                        ) pvt
                        PIVOT (
                        MAX(bar) FOR foo IN ([foo], [bar])
                        )p
                        [/code] …

                        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  ·  Qualify Object Names  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add Comment Block to Surround With choices

                          Can you add a comment block /* */ to the Surround With choices? It would be of great use.

                          I also like the idea of adding Surround With options to the snippet editor where one could specify the before and after.

                          The example one person gave was Surround With ISNull( <highlighted column> ,0)

                          8 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 →
                          • Sort Suggested Columns in a Table Alphabetically or in Table Order

                            Is it me or did the latest release change the sort order of the columns to table order instead of alphabetical order? I don't know if SQL prompt changed or if my brain changed.

                            When intelisense comes up for column names, I would like to see the column names in alphabetical order. Right now it comes up in the order the columns are defined in the table which is fine but I would like the option to go alphabetical as well. It'd be nice if that was a user preference.

                            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 →
                            • Rename Open Tabs

                              I noticed the Tab History that you can rename closed tabs. It would be great if one could rename open tabs. I am constantly flipping between tabs thinking Query1 is the one where I querried table A, Query6 was the one where I updated reference table B. etc etc,,, It's a total pain.

                              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 →
                              • Ability to Disable Code Suggestions and Snippets Separately

                                There are times the performance of Code Suggestions is slow due to the large number of database objects or simply a slow computer. There have been times I needed to disable the Code Suggestions but I still needed the snippets. It would be good to be able to allow developer to decide which feature to turn quickly disable/enable.

                                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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                • always start case statement on new line

                                  I want to be able to keep my column list on one line but separate out case statements on its own line.
                                  Ex:
                                  Select strName, strAddr, strPhone,
                                  Case bitNewData When 1 Then 'Yes' Else 'No' End as NewData

                                  OR block but on its own lines:
                                  Case bitNewData
                                  When 1 then 'Yes'
                                  Else 'No'
                                  End as NewData

                                  At minimum, an option to ignore case statements when formatting so it stays as I formatted it.

                                  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 →
                                  • Highlight all occurences of selected identifeir/word

                                    When dealing with large scripts it would be really helpful to have highlighted all occurences of selected identifier or word.

                                    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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Let cursor jump to capitalized letters within words (CTRL+arrow)

                                      Hi there. Would it be possible to program a feature that is
                                      present in Visual Studio (I think ReSharper brings it
                                      into VS) which enables a programmer to select/move among
                                      parts of a word based on where the capital letters are? (CTRL+arrow)
                                      Say you have a variable called @ThisIsMyVariable.
                                      If you place the cursor at the end of the word and then
                                      press CTRL+<Left Arrow>, then it’d be nice if the cursor
                                      jumped to the beginnig of the next capital letter instead
                                      of the next word as is usual. This feature is very helpful in VS and I think it’d…

                                      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  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Warning on delete and update statements if no WHERE clause is specified

                                        It would be nice to get a warning on delete or update statements if you did not specify a where clause.

                                        8 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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Pin feature for quick info

                                          When the mouse pointer is hovered over a table or stored procedure etc, an intelli-sense like link is shown which can clicked to bring up the object definition, which disappears when something else is selected.

                                          My suggestion would be a pin feature, so that we can keep the object definition quick info box visible on the screen for reference instead of it disappearing.

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

                                          Feedback and Knowledge Base