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. Don't suggest join keys I've already used

    After I type
    SELECT * FROM sys.indexes i
    INNER JOIN sys.partitions p
    ON i.index_id = p.index_id
    AND

    the IntelliSense still suggests me i.index_id = p.index_id which I've already used. These duplicates can become pretty annoying when multiple columns are used for joining

    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 →
    • Include any referenced object in Summarize Script

      At the moment we have basic SELECT statement handling in Summarize Script, only showing whether it is a SELECT FROM <table> or SELECT <expression>.

      So a query such as

      USE [AdventureWorks2014]
      GO
      select
      (select top 1 emailaddress from Person.EmailAddress),
      dbo.ufnGetPurchaseOrderStatusText(1)
      from Person.Person

      Would only show

      SELECT from Person.Person

      Would be useful to also show any tables referenced in a subquery, and also UDFs.

      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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
      • Generate SET [OPTION] for when altering procedures

        When auto-generating source for ALTER PROCEDURE, make sure to replicate the original options settings. For example, generate a "SET QUOTED_IDENTIFIER OFF" if the procedure originally had this setting.

        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 →
        • grid 'friendly' view

          it would be useful to have an option to quickly format the numbers in the resultgrid with commas and an optional number of decimal places. If i'm troubleshooting data with large numbers then I have to export each result set to excel and format the numbers manually each time so I can see what they are.

          for example, if i have just a few rows/columns with numbers in the millions then having numbers formatted as

          312,765,253 is easier to read than 312765253.12

          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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
          • Ping Tabs in History

            It would be really nice to be able to pin a tab in the history. On a daily basis, I can work with dozens to hundreds of tabs. My tab history gets extremely cluttered with stuff I no longer need, but it buries the stuff I want to stay in my tab history.

            That means I have two choices:
            1. Scroll to the bottom of a very long list about 10 - 15 times and open then close the tabs I want to stay in history, just so that they are the most recent ones open. Then I can actually…

            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 →
            • Tab History Cloud Sync

              Option to sync/store tab history in the cloud, network share, or online share (aka One drive, Google drive, dropbox, etc.) That way you don't loose your history when you upgrade or change your computer and have to start all over again. It would also be nice to be able to sync between multiple computers.

              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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
              • Multi-line find and replace

                I find myself frequently starting from an existing script and making substitutions. This is most common when we are refactoring unit tests. One of the more common scenarios is to be able to do something like "Find 3 specific lines of code and replace with 2 other lines of code". When we have to do something like this, it isn't one or two objects, but instead we're modifying 200 - 1000+ objects and doing the manual copy/replace can consume hours and days.

                I've tried everything I can think of, including other products such as Word, WordPad, Notepad++, Sublime, etc. The…

                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 →
                • Object Explorer Remember Servers

                  SSMS currently has 2 different views for looking at servers. One is Registered Servers and the other is Object Explorer. Combining the two would lead to a much better experience. In tools like DataGrip and dbForge Studio, this is exactly what they do by default. You register the servers you're interested in up front and they show up every time you launch in what is the equivalent to Object Explorer. They even include the color coding to identify the server environment while browsing in the tree.

                  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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                  • Remove/rename duplicate columns in wildcard expansions

                    It'd be awesome if SQL Prompt could have the ability to automatically (or via key command) remove and/or rename columns that are duplicated when joining tables.

                    That is, if you have three (3) tables defined and filled as such:

                    DROP TABLE dbo.Grades
                    DROP TABLE dbo.Student
                    DROP TABLE dbo.Course

                    CREATE TABLE dbo.Student
                    (
                    sid INT IDENTITY(1,1) NOT NULL,
                    fname VARCHAR(10),
                    lname VARCHAR(50),
                    CONSTRAINT pk_Student PRIMARY KEY CLUSTERED (sid)
                    )

                    CREATE TABLE dbo.Course
                    (
                    cid INT IDENTITY(1,1) NOT NULL,
                    cname VARCHAR(50),
                    CONSTRAINT pk_Course PRIMARY KEY CLUSTERED (cid)
                    )

                    CREATE TABLE dbo.Grades
                    (
                    sid INT NOT NULL,
                    cid INT NOT NULL,
                    grade VARCHAR(2)…

                    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  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
                    • change cast to convert or viceversa when formatting.

                      So it doesn't matter if some developers preffer to use cast or convert in their codes. Of course when convert is used with style, it must remain convert.

                      Also for try_cast and try_convert.

                      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 →
                      • 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 →
                        • ExecuteCurrentStatement prompts error if overall script syntax is incorrect

                          ExecuteCurrentStatement is a wonderful command! I have bound to Ctrl + Enter and it's saved me tons of times without having to highlight a query (god knows where some of them start and end sometimes)

                          Unfortunately, it doesn't work when there are syntax errors in somewhere else in the script. For example:

                          /****** Code start ******/

                          UPDATE MyTable
                          SET SomeValue = 5
                          WHERE SomeRow =

                          // What was the SomeRow value I wanted to look for again?
                          // So I write another query to look for it

                          SELECT SomeRelatedRow
                          FROM MyRelatedTable

                          /****** Code end ******/

                          It's a simple example (sure,…

                          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 →
                          • Execute highlighted statement with variables

                            It would be cool if there was a way to handle this situation: highlight a selection that contains variables that are not declared within the highlighted section. I run into this CONSTANTLY and drives me crazy. Every time I try to think of the best way to accomplish handling this I think of 10 different ways and features and settings that could be implemented. So, I'd rather just give you guys the basic idea, and see where it goes from there. At the very least, I would like the ability to highlight a query, hit run and if there is…

                            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 →
                            • Correctly handle datetimes for open in excel

                              Excel does not understand timestamps with an ms part, it should be removed when sending a result set to excel.

                              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 →
                              • order by

                                When Ordering by column numbers, formatting the SQL would replace the column number with the qualified column name. e.g.

                                Order By 1,2,3,4 would be come
                                Order By t.TerritoryName,
                                d.DivisionDescription,
                                r.RegionDescription,
                                s.Name

                                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  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                • linux

                                  SQL Server on Linux please.

                                  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 →
                                  • Add Intellisense Support for USQL in Visual Studio

                                    Can we have USQL intellisense support within Visual Studio when developing with Azure Data Lake please? This would be really helpful please.

                                    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 →
                                    • Align equals sign in UPDATE

                                      Provide an option in Styles to let the right hand side of clauses in UPDATE statement be aligned.

                                      Example:

                                      UPDATE~~EDSV
                                      SET~~~~~eDocSessionID~~~~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionID~,
                                      ~~~~~~~~eDocSessionKey~~~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionKey~,
                                      ~~~~~~~~eDocSessionValue~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionValue~,
                                      ~~~~~~~~eDocSessionValueTextStyleOverride~=~CONSV.eDocSessionValueTextStyleOverride~,
                                      ~~~~~~~~eDocSessionValuePositionOverride~~=~CONSV.eDocSessionValuePositionOverride~,
                                      ~~~~~~~~eDocSessionValueLockdown~~~~~~~~~~=~''
                                      FROM~~~~eDocStd2.dbo.eDocSessionValues~AS~EDSV
                                      ~~~~~~~~INNER~JOIN~#changedOrNewSessionValues~AS~CONSV~ON~CONSV.eDocSessionID~=~EDSV.eDocSessionID
                                      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~AND~CONSV.eDocSessionKey~=~EDSV.eDocSessionKey;

                                      17 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        2 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Diff output from two procedures

                                        Say I'm rewriting a stored procedure - replacing some tables as part of a restructuring of some data. What I'd like is to be able to execute both procedures with identical parameters and to get a diff of their output. The diff should include:
                                        - Diff of all output columns (the number of columns returned and their names)
                                        - Diff of the data output (column values and order returned)
                                        - Diff of any output parameter values, post execution

                                        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 →
                                        • recognize 'DROP Object If Exists"

                                          doesn't currently recognize the newer DROP OBJECT IF EXISTS when formatting SQL

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

                                          Feedback and Knowledge Base