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. Add snippet support for block editing

    I use block editing all day long. I have some snippets I would like the ability to use while block editing...for example (arguments aside on when to use WITH(NOLOCK) this is just an example for the feature request):

    I would use block editing to place the cursor before ON on all 4 of the join lines and then use my snippet to place WITH(NOLOCK)

    This query:
    SELECT *
    FROM DBName.dbo.Table1 t
    JOIN DBName.dbo.Table2 t2 ON t2.ID = t.ID
    JOIN DBName.dbo.Table3 t3 ON t3.ID = t2.ID
    JOIN DBName.dbo.Table4 t4 ON t4.ID = t3.ID
    JOIN DBName.dbo.Table5 t5 ON t5.ID = t4.ID

    Would…

    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 →
    • Format column list in SELECT query to "ColumnName = blah.ColumnName"

      When I have a query with more than 2 or 3 columns, I usually like to put each column on a new line, and format it using the style: "ColumnName = blah.ColumnName"

      For example, this query, would result in

      SELECT t.Column1
      .........., t.Column2 AS TestCol2
      .........., FooBar = t.Column3
      FROM DBName.dbo.Table t

      This query (and an option to keep the = signs all in line would be nice too):
      SELECT Column1 = t.Column1
      .........., TestCol2 = t.Column2
      .........., FooBar = t.Column3
      FROM DBName.dbo.Table t

      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  ·  Flag idea as inappropriate…  ·  Admin →
      • Disable auto alias, but allow custom aliases

        Basically, I want the option to only use my supplied custom aliases...otherwise no alias is applied.

        It throws of my momentum when I'm writing queries when I join in a table, and it auto generates the alias, but it's not one I'm use to seeing. So I'd like the ability to disable auto generated aliases, but still apply custom ones.

        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 →
        • 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 →
          • Add option to make table aliases not bracketed

            I would like the ability to automatically put brackets around all SQL objects, except for table/function aliases

            Example

            SELECT
            A.[Foo],
            B.[Bar],
            [Foobar] = A.[Foo] + B.[Bar]
            FROM
            [dbo].[MyTableA] A
            CROSS JOIN [dbo].[MyTableB] B

            instead of the current all or nothing of

            SELECT
            [A].[Foo],
            [B].[Bar],
            [Foobar] = [A].[Foo] + [B].[Bar]
            FROM
            [dbo].[MyTableA] [A]
            CROSS JOIN [dbo].[MyTableB] [B]

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
            • Support linked servers from SQL Server to Azure SQL Database

              Enable all functionality for linked servers from a traditional SQL Server instance to Azure SQL Database. Currently, Intellisense does not work, and there are red squigglies on all code using the linked server.

              Here are the instructions for creating this type of linked server:

              http://stackoverflow.com/a/41145784/1867657

              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 →
              • Bug with multi-level schemas

                We have multi-level schemas in our MS-SQL databases, e.g.
                [myapp]
                [myapp.config]
                [myapp.refdata]

                When typing in object names, SQL Prompt is not dealing with this well. Up until today, I could type myapp.c and then select myapp.config. The result would then be
                myapp.[myapp.config] instead of [myapp.config]

                After installing version 7.4.1.603 today, as soon as I enter the period/dot, the list of schemas disappears, so I have to type myapp then select the subschema from the list.

                If you need more version details or a live demo (video-capture) I would be happy to oblige.

                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 →
                • Support multiple instances of SSMS to be open at the same time

                  I regularly have multiple instances of SSMS open with many scripts open in each. I often work on multiple servers or environments at the same time. Either running multiple scripts on each or working in one while keeping an eye on the output in another.

                  After a while SQL Prompt will crash SSMS when I do this.

                  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 →
                  • Merge Update and Inserts List Suggestions

                    It would be great if when you are doing a MERGE and get to the 'WHEN MATCHED THEN UPDATE SET' SQL Prompt would generate a list of all the Target columns and have them set to be equal to the Source columns where the Target column names match the Source column names. Likewise, in the 'WHEN NOT MATCHED BY TARGET THEN INSERT' section it would be nice if SQL Prompt would generate the list of source column names in the Target followed by a column list of all the Source column names in the Source where the Source and Target…

                    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  ·  Flag idea as inappropriate…  ·  Admin →
                    • tab foreground color

                      Allow foreground (text) color to be specified. Some background colors cannot be used because black text is not readable.

                      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  ·  Tab coloring  ·  Flag idea as inappropriate…  ·  Admin →
                      • Indentation after END CATCH is not restored to previous level

                        The indentation of a try-catch block is correct inside the block, but it doesn't return to the original level after END CATCH. A long script with a lot of try-catch block shows an ever-increasing indent level.

                        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 →
                        • Placeholder Substring

                          It would be handy to allow for a substring function around the placeholder. So that if the placeholder value needed to be altered slightly the same way you could replicate the alteration easily in your snippet. I think this would be a very flexible addition to the placeholder functionality.

                          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 →
                          • Do not indent BEGIN TRAN

                            The corresponding COMMIT lines are often inside a nested BEGIN END block, so decreasing the indent inside that block would look odd. Without a good answer for unindenting COMMIT, the effect of indenting BEGIN TRAN (where it appears mulitple times) is an increasingly ridiculous indent toward the end of a procedure or script.

                            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 →
                            • Disable Auto Generated INSERT Statement By Keyboard Shorcut

                              Auto generat INSERT statement is a great feature. But some times I come across a table with a lot of columns and do not want prompt to generate insert statement only for one time.

                              Maybe it should be like this :

                              Enter will generate full insert statement
                              Shift + Enter will generate only table name.

                              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 →
                              • Export to Libre Office / OpenOffice Calc

                                I find that Excel 2016 is a lot more buggy than 2013 and doesn't handle spreadsheets over about 250K very well, so for large sheets I'm having to resort to Libre / Open Office. If I set Calc as default for Excel, then it opens OK but commas (for example) get replaced as _0x2c_.

                                This isn't urgent, but until MS get around to fixing Excel again, it would be useful.

                                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 →
                                • Open in Excel and the MRU

                                  When Open in Excel is clicked in the grid right-click menu, the resulting workbook with a name like "Exported results 207-02-07_09-14-27.xlsx" is added to Recent Workbooks (File - Recent - Recent Workbooks) formerly known as the Most Recently Used list.

                                  I would prefer if no entry was made to the list. If I want to save the results, I will rename the workbook.

                                  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 →
                                  • Enable "reconnect to server" on tab activation rather than SSMS startup

                                    I frequently have a lot of tabs open, and this makes startup painfully slow. I would like this to work the same as tabs do in firefox; show open tabs as placeholders until activated, and only then load content and reconnect.

                                    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 →
                                    • grid aggregates

                                      Results Grid aggregates
                                      SUM, AVG, MIN, MAX and COUNT aggregates are shown
                                      for selected range of cells in Results Grid open a new window with this reslults

                                      like http://www.ssmsboost.com/VersionCompare

                                      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…)
                                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • SQL Formatter error

                                        When using OPENJSON with the WITH clause, the formatter does not recognize the WITH clause as valid SQL. This should format but throws an error:

                                        DECLARE @JSONString NVARCHAR(MAX) SET @JSONString = N'{"Vendors":[{"VendorNumber":200,"VendorName":"Vendor1"},{"VendorNumber":201,"Vendo2"},{"VendorNumber":202,"VendorName":"Vendor3"}]}'

                                        SELECT VendorNumber ,
                                        VendorName
                                        FROM OPENJSON(@JSONString, '$.Vendors')
                                        WITH (VendorNumber INT '$.VendorNumber', VendorName VARCHAR(50) '$.VendorName')

                                        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 →
                                        • Refactor - rename column aliases

                                          Renaming column aliases is not working and it might be very useful feature. Lets see following example:

                                          SELECT Totals.Sales
                                          FROM (SELECT 5 AS Sales) AS Totals

                                          If You press F2 on table alias [Totals] it works perfectly. However if You need to change alias of column [Sales] and You will press F2 nothing happens beside proper highlighting of this column name.

                                          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  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 30 31
                                          • Don't see your idea?

                                          Feedback and Knowledge Base