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. exclude comments from "start new line at Boolean operator"

    I frequently mark up JOIN and WHERE conditions with comments indicating why I am filtering them, like in the following:

    SELECT TABLE_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE
    1=1 AND --stay put!
    2=2

    However, when the "start new line at Boolean Operator" is enabled under Format > Expressions, SQL Prompt will place the comment on a new line after the condition:

    SELECT
    COLUMNS.TABLE_NAME
    FROM
    INFORMATION_SCHEMA.COLUMNS
    WHERE
    1 = 1 AND
    --stay put!
    2 = 2

    Can this be configured to allow comments to stay where they are, even when the "start new line at Boolean operator" option is enabled?

    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 →
    • Smart Rename via Synonym

      Being able to have Smart Rename also generate a synonym of the old name, pointing to the object with the new name, would be very useful in scenarios where there is external code pointing to specific database objects that you're renaming.

      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  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
      • Show part of the sql text on the tabs hint

        You could show at the tab hint, the first lines of the query typed on that tab. It'll help a lot to localize a especifi query among a lot of tabs opened.

        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  ·  Tab coloring  ·  Flag idea as inappropriate…  ·  Admin →
        • Execute current statment

          Shift-F5 is great but I think this change could make it better.
          Before I discovered Shift-F5 and when I had multiple sql statements in my window, I would select the block of sql I wanted and hit F5 to just execute that code block. Then I discovered Shift-F5 and I no longer had to select my sql block it was done for me - but what it doesn't do is actually select the code block, instead it just highlights it in green and executes it. So if you just do an F5 (out of habit) after a Shift-F5 it won't…

          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  ·  Flag idea as inappropriate…  ·  Admin →
          • Configurable Execution Warnings

            The new Execution Warnings functionality to warn of UPDATE or DELETE statements without a WHERE clause is great; however, the warning triggers even when the code is in the definition of a Stored Procedure.

            It would be good then to have advanced functionality to allow for us to be able to select whether to warn on SP definition text, or to turn on the warnings when running against temporary tables.

            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…)
              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
            • Auto-Close of /* should be --*/

              Add an option to allow /* to be auto-closed with --*/ rather than just */.
              There are a long list of ways that using this syntax allows coding of more easily tested statements and, in general, making troubleshooting of complex procedures easier. At the same time turning it on doesn't hinder normal comment use in any way so there are no real drawbacks to making it your default.

              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  ·  Flag idea as inappropriate…  ·  Admin →
              • Update a column name if I add or change an alias in a CTE

                For example:

                WITH x AS (SELECT 1 AS ColName)
                SELECT x.ColName
                FROM x

                If I change the ColName alias in the CTE, the outer select will become invalid. Perhaps this could be an extension of the F2-rename feature.

                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 →
                • Keep pinned status

                  In SSMS 2016 you can now Pin tabs. When you close and re-open SSMS, it would be good if Tab History could remember, and restore, the pin status for each of the tabs as they are being restored.

                  3 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                  • Recommend table structure

                    It would be sweet if I could right-click a table and get suggestions for better data typing of my columns. For example, I found a nasty table that used only VARCHAR(MAX) for all their columns. I would need to manually sample all the data to understand what I could possibly use instead. It would be sweet if the tool could sniff the data and recognize that I could use INTEGER or SMALLINT, Date or Datetime, or just a smaller size than VARCHAR(MAX) for the column data types. Maybe even show the estimated space savings. :)

                    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  ·  Flag idea as inappropriate…  ·  Admin →
                    • Provide user feedback when Ctrl-F12 can't find the object because the server isn't open in the object explorer

                      If the server isn't open in the object explorer then Ctrl-F12 can't select the object, but SQL Prompt doesn't provide any feedback to the user. This can be confusing as it could be down to SQL Prompt not refreshing, or suggestions being turned off.

                      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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • Enhancement to "Warning on delete and update statements if no WHERE clause is specified" (clarified)

                        This is a clarification to an earlier post. (https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/13543761-enhancement-to-warning-on-delete-and-update-state)

                        This is a great idea, but I was surprised by the number of "false positives" I am getting (and yes, I can just mute the messages completely).

                        In my case I am doing a lot of updates/deletes on permanent tables with joins to temporary tables or table variables and that limits the update/delete scope.

                        Can you add to this feature so that messages will not be emitted if there is a join to a temporary table or table variable?

                        For example...
                        Update dbo.RealTable
                        Set SomeData = tt.SomeData
                        From dbo.RealTable…

                        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…)
                          3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Suggest the field when used the clause "isnull"

                          Suggest the field when used the clause "isnull"
                          for example when using the code:

                          where person.autoid = isnull (@IdPerson, "person.autoid")

                          To do that field in brackets be suggested, as is almost always used the same field that is in comparison.

                          Excuse my english.

                          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 →
                          • CSV Export with Ecapsulation

                            I really like the feature that enables the export of the result grid to Excel. But for big data sets it would be more useful to have a csv export that improves on Microsoft's i.e. supports encapsulation with double quotes "Data1","Data2","Data3" etc - this could be extended to permit the user to select a delimiter other than a comma, tab for example.

                            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 object script to New Query

                              Copy object script to New Query

                              When accessing an object's definition using the popup (which is accessed from the intellisense menu), it would be great if there was an additional button (next to the existing Copy button) which copied the contents of the object's script to a new query window.

                              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 →
                              • Intellisense support for hypens/dashes in table names

                                When a table name contains a dash or hyphen "-" (i.e. dbo.Daily-Holdings), the intellisense stops working after you type the dash/hyphen

                                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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                • Sum selected columns

                                  It would be nice to have some capabilities that exist in Excel 2013. Specifically the feature when you can highlight a column and then at the bottom of the application it gives you some quick statistics for the column. So if I had a column of numbers, and I highlighted the column in the results pane it would give me the Average of the numbers in that column and the sum of the numbers in the column. If the column was text you could see the count of distinct values in that column. This just gives quick access to statistical…

                                  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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Change Table Icon for Trigger

                                    Can we get an change in the table icon, or an indicator in intellisense (ideally both), that lets someone know there is a trigger on a table? Triggers are often hidden, and it would be nice to have them marked in SSMS, as well as noted when someone is altering or querying a table.

                                    11 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                    • MERGE - Highlighting

                                      It would be nice to have consistent behavior between an INSERT statement and the INSERT within a MERGE statement. When I have an INSERT statement, when I move across the column names, the corresponding column/value in the VALUES clause is highlighted and vice versa. When I attempt to do the same thing for an INSERT within a MERGE statement, I get nothing. No highlighting at all. This makes it extremely tedious to figure out if you have a mismatch between the column list and VALUES clause of the INSERT. The only way I've found to do this is to rip…

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

                                        Can you do to allow comment the selected text and not the whole line?

                                        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 →
                                        • Prefered server Connection List

                                          When working all day long with serveral SQL servers, its really annoying to click on "change connection" button + enter the server name you want to connect to, and enter credential.... It would be really great we we would have a "server connection list" where we could build into settings.... So i could add all my server i'm use to connect everyday, and specifying the USERNAME + PASSWORD + Default DB..... So in one-two click, i could switch to another server really quicly

                                          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…)
                                            2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 23 24
                                          • Don't see your idea?

                                          Feedback and Knowledge Base