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. Option to remove font smoothing in tab history

    Due to eye problems I have to work without font smoothing - any type, be it grayscale or cleartype will give me a headache.

    As such, the tab history - which is usually incredibly useful - I can only use for maybe a minute or two.

    Can you build a way to change the look of the screen to remove the font smoothing?

    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 →
    • embedd any of the existing sql prompts short cuts within a snippet

      I have an sql template that I am have assigned to a snippet which allows me to create standard stored procedures straight from MSSQL management studio, works like a charm.
      However I have a parameter of the template that asks for the main table being used.
      <Table,,> which is replaced in the stored proc template with whatever the table name is.

      Then inside the template have a simple select * from <table,,>
      which when run as a snippet produces a line of code , select * from tablename.
      What I would like to be able to do is utilise the…

      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 →
      • Extract a Table defintion from a SELECT ... INTO....

        There have been many times when I've been working with a procedure that has one or more SELECT ... INTO, usually to create a temp table.

        If I want a CREATE TABLE definition for the table created that way, I have to change the procedure to SELECT ... INTO a permanent table then script out the definition of the table.

        It would be very helpful if SQLPrompt had a way to generate the CREATE TABLE statement from the SELECT ... INTO (even if the data types aren't perfectly correct)

        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 →
        • Put the snippet XML in comment block

          Change the snippet file format so it's editable and runnable in Management Studio by putting the XML portion in a SQL comment block.

          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 →
          • semi colon placed on new line

            Place semi-colon on new line.

            I frequently format my statements as I'm developing them, but multiple times now I've started to add an Order By or some other clause after the auto-inserted semi-colon. I would like to see an option to place the semicolon on the line following the sql statement rather than directly after. This would enable me to start typing at the start of the next line without having to check if a semicolon had been added to the preceding line.

            Example:
            Select * From Table
            Where A = 1; -- Semicolon added by formatting
            Order By A

            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 →
            • Autocorrect for Missing * in select statements with no fields: Select top 10 from table-> select top 10 * from table

              Automatically fill in Missing * from select statements: For example:
              Select from table -> Select * from table
              Select top 100 from table-> Select top 100 * from table
              Select into table... you get the point.

              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 →
              • Exclude Identity Field From Auto Generated Insert/Values Code For Table Variables

                If a table variable or temp table has an identity field, I do not think this field should show up in the auto generated insert into/values list:

                DECLARE @Table TABLE (TableId INT IDENTITY(1,1), Data VARCHAR(100);

                INSERT INTO @Table
                ( [TableId] -- This field show not show up by default in the insert list
                , [Data] )
                VALUES ( 0 -- TableId - int -> This field show not show up by default in the insert values list
                , '' -- Data - varchar(100)
                )

                -- Temp Table
                CREATE TABLE #Temp (TableId INT IDENTITY(1,1), Data1);

                INSERT INTO [#Temp] ([TableId],
                [Data1]) 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…)
                  2 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                • in "summarize script", an "if" and its "else" should be on the same level

                  This statement:

                  IF condition
                  ...
                  ELSE
                  ...

                  is semantically equivalent to this pair of statements:

                  IF condition
                  ...
                  IF NOT condition
                  ...

                  That's how I think of them. SSMS and SQL Prompt treat them that way; If I use SQL Prompt to format my SQL, and SSMS's "outline statements" feature to collapse regions of code, then an IF/ELSE statement looks like this:

                  IF @I = 1
                  [+] BEGIN [...];
                  ELSE
                  [+] BEGIN [...];

                  The IF block and the ELSE block are treated as two separate IF statements with equal importance. The ELSE keyword lines up with the IF keyword, and…

                  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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
                  • Unwrap a view

                    Sometimes I start using an existing view as base for a new SQL query. Often I end up like this:
                    SELECT o.Id
                    ,o..........
                    ,e.name
                    ,e.....
                    FROM vOffice AS o
                    LEFT JOIN Employee AS e ON o.Id = e.OfficeId

                    When I end there, I would like an easy way to right-click vOffice-view and then let SQL-prompt "translate" the view back to its original table name(s) and joins.

                    By doing this I can easily use the other columns that this view has not included - and create a new view that is not based on another view.

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

                      19 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 →
                      • 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.

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

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

                            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 →
                            • 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. :-)

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

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

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

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

                                          13 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…)
                                            3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 19 20
                                          • Don't see your idea?

                                          Feedback and Knowledge Base