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

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

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

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

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

                        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 →
                        • Refresh all suggestions.

                          When you create a new table or view, add that data schema to the suggestions instead of having to refresh all suggestions.

                          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 →
                          • Reformat table joins which use a comma and criteria in the WHERE clause to table joins which use INNER JOIN and criteria in the ON clause

                            Queries generated automatically by some reporting or business analytics packages often use the following format for SELECT statements:

                            SELECT *
                            FROM tableA a, tableB b, tableC c
                            WHERE a.uniqueIDa = c.uniqueIDc
                            AND a.foreignkeyA= b.columnB

                            or something similar. I would like to have the (optional) ability to reformat this type of syntax to:

                            SELECT *
                            FROM tableA a
                            INNER JOIN tableB b
                            ON a.foreignkeyA= b.columnB
                            INNER JOIN tableC c
                            ON a.uniqueIDa = c.uniqueIDc

                            I don't know if this is possible in all cases to do automatically, and it could in some cases alter the results of the query (?), but it…

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

                                          Feedback and Knowledge Base