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. Copy column from grid results as comma separated list

    Oftentimes when I am writing queries, the results from one column of one query are quickly needed in my next one in an IN clause. I highlight the column of values from the results grid and paste into the query window, and then have to append commas (and for neatness, I delete the line breaks). I would be nice to have an added option the context-menu of the results grid to add a copy as comma separated list (in addition to the current copy and copy with headers options).

    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 →
    • Include full Table name in Alias popup

      When hovering over an alias a pop-up or hint appears which only tells you that it is a table, eg for oe.Job J. Later in code J.Name = @Name. Popup shows:

      J(Table).

      Drilling down gives the columns which may help.
      However if it showed something like:

      J = oe.Job (Table)

      then this would be a good quick reference eg when trying to understand a long complicated query written by someone else with numerous aliases.

      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 →
      • IF statement format options

        Please provide the option to format IF statements as follows, based on the format settings sample.

        IF @productType IN ('a', 'b', 'd', 'g', 'i', 'O', 'Q', 'X', 'Z') BEGIN

        ----IF @cost <= @compareprice BEGIN

        --------PRINT 'Less than $' + CAST(@compareprice AS varchar(20))

        ----END ELSE BEGIN

        --------PRINT 'Exceeds $' + CAST(@compareprice AS varchar(20))

        ----END

        END

        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 →
        • Autocomplete stored procedure With DEFAULT Values

          When autocompleting a stored procedure statement in the format 'EXEC storedProc @param1 = 0, @param2 0' it would really help if the parameters would initially have the default values defined in the stored procedure (if applicable).

          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 →
          • Highlight Implicit Conversions due to Data Type mismatch

            After spending some time refreshing my memory on implicit conversions, and the potentially disasterous affects on performance, the thought hit me...

            Wouldn't it be great if SQL Prompt could hightlight potential implicit conversions when I write JOINS or WHERE statements?

            I'm not sure how easy this would be to implement but I know everyone at Red Gate is very intelligent and highly creative so you'll find a way. :-)

            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 →
            • Format comments to the level of the following line of code

              SOL Prompt grid-based formatting is awesome. We all know this. It is pretty much the industry standard. But it messes up in one way that causes much consternation among our DBAs, namely in how it treats comments.

              In our code (and most example code I've seen out there) comments are most frequently placed preceding the section of code it describes. One would expect a reformatting to indent the comment to the level of the following line of code, for easy visual reference.

              However, SQL Prompt always reformats comments by indenting them to the level of the parent clause, which appears…

              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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
              • Thanks for providing a feature to find all the unused variables but can you please provide a feature to comment/remove unused variables?

                Step 1: At first I want to comment out all the unused variables.
                Note: In these comments there must be a keyword (e.g. UVC To make it different from other comments) which can be helpful to remove it later after proper testing.

                Step 2: After some testing(may be in if I find everything works fine I want to remove all the unused variables permanently to make a final copy.

                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 Unused Variables  ·  Flag idea as inappropriate…  ·  Admin →
                • Keyboard macros

                  Create ability to write keyboard macroses. For example I have following lines:
                  column1 as varchar(100),
                  column2 as int,
                  ...
                  column117 as uniqueidentifier primary key

                  I want to get all column names. What I usually do, I am copying it to external editors that support macroses and record it on the first line with following actions:
                  hold_ctrl+right(cursor goes to the end of column name), hold_shift+press_end_button (highlights entire row),press_del (to delete this text),press_,(to add comma at the end),press_down(to go to the next row),press_home (to return at the beginning of the second row)
                  Then I replay this macro and I have just column…

                  10 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 extra features to object generation code when the mouse cursor points to object in editor

                    When I point on the object in editor it generates the script for that object. It would be nice to have some kind of dropdown list with checkboxes or something like that to add some extra conditions what objects to generate. For example for table it generates: table code, constrains, indexes... Sometimes I want to see there triggers, maybe permissions, something else.

                    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  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
                    • Automaticaly replace SELECT 8 by SELECT *

                      I don't know how many time a day I end up typing SELECT 8 instead of SELECT *. It would be nice if SQL Prompt could automaticaly detect this and correct 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  ·  Flag idea as inappropriate…  ·  Admin →
                      • Indicate if an object is SELECT only or contains data insert/update/delete operations

                        Often when reviewing someone else's objects I have to open them and scan through to determine if they are truly read only or if they contain data modification code (delete,update, insert, merge, etc...). It would be most helpful if SQL prompt could show a flag for read only vs data mod objects (when you hover over and click to open the summary window displaying it there would be ideal). It would be best if it could check dependencies (if the object called others)

                        10 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 →
                        • LINQ Style SQL

                          What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).

                          The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like…

                          14 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 →
                          • RECEIVE statement - Format SQL ignores

                            ;
                            RECEIVE TOP(1)
                            @h = conversation_handle,
                            @t = message_type_name,
                            @b = message_body
                            FROM Simple_Queue_Target

                            From the Service Broker Workbench on Simple Talk.

                            It only moves the semicolon to a separate line. No errors. Ignores "comma at start".

                            And, yes, the @'s above probably start in column 1, when they're actually in col 5.

                            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 →
                            • Offer Intellisense when renaming an object

                              It would be helpful if Prompt showed Intellisense where you put the OldName :

                              EXEC sys.sp_rename @objname = 'OldName', @newname = 'NewName'

                              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 →
                              • MDX History

                                I *love* the capture Sql history - it is very useful. It would be just as useful if Sql Prompt could also capture and save off the MDX submitted in SSMS.

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

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

                                          Feedback and Knowledge Base