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?

(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. SQL Over Clause

    Could we have an option to force the over clause to a new line?

    Case
    When Lag(Sum([Acting Non Pensionable Allowance]), 1, 0) Over (Partition By [Operation], [Remuneration Method] Order By [Cost Month]) = 0
    Then 0
    Else

    Should look like:

    Case
    When Lag(Sum([Acting Non Pensionable Allowance]), 1, 0) Over (Partition By [Operation], [Remuneration Method] Order By [Cost Month]) = 0
    Then 0
    Else

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

      We’ll send you updates on this idea

      0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    • Edit Top N Records from SQL Editor

      The MS Management Studio allows to right-click table in Object Explorer and select "Edit top rows". Similarly add a option to do it in SQL Editor. So user can right-click table name from his query and edit data directly.
      Similar Addon:
      http://www.ssmsboost.com/Features/ssms-add-in-edit-table-directly
      menu-Screenshot:
      http://1.bp.blogspot.com/-CEJkwbkjnZQ/VqEZHRo8RWI/AAAAAAAAGkQ/TQKiddLQge8/s1600/1.png

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

        We’ll send you updates on this idea

        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Support for Microsoft SQL Operations Studio

        Microsoft SQL Operations Studio is in preview mode and shows a lot of potential. I would probably switch from SSMS right now if SQL Prompt was supported. Please add SQL Prompt!

        13 votes
        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)

          We’ll send you updates on this idea

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

            We’ll send you updates on this idea

            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
          • "Dependencies" tab in the information popup for DB objects other than columns.

            Clicking the Hover hyperlink for a column will produce a Dependencies tab (awesome, BTW). The Hover Hyperlink for (most) other objects will give Script and Summary tabs (also awesome). What would make it even more awesomer would be to produce a Dependencies tab for these other objects as well.

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

              We’ll send you updates on this idea

              0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
            • Fix the SIPFramework.AddIn

              Might be nice for you to have an easy Remove/Add feature so when your AddIns fail, you can remove then and reapply them. Just getting the error ''The parameter is incorrect" is not overly helpful.

              0 votes
              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)

                We’ll send you updates on this idea

                0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
              • Recover XMLA queries as well

                Tab History is ideal for recovering SQL queries. When SSMS crashes, all .sql queries are nicely put back. However, any XMLA queries (and perhaps MDX and DAX as well) aren't recovered. It would be great if all types of queries could be recovered.

                2 votes
                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)

                  We’ll send you updates on this idea

                  0 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                • Improve Synonym Support

                  When you have an outdated synonym (synonym referencing an entity that no longer exists) then SQL Prompt returns a "Can't Connect" error with no explanation why; furthermore that synonym wasn't even in use in the SQL code I was trying to format. Can't SQL Prompt at least tell me there's a bad synonym? Or give ANY indication what's wrong?

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

                    We’ll send you updates on this idea

                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Extend code inlining to Functions

                    Inlining stored procedures is very helpful when debugging. Please extend this functionality to functions as well

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

                      We’ll send you updates on this idea

                      0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                    • Copy entire contents of grid cell

                      I would like the ability to select a cell in the grid results and copy the entire contents of the cell, rather than it being truncated. Currently, I’m able to “Copy as IN clause” then remove the unnecessary characters, but this is a bit cumbersome.

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

                        We’ll send you updates on this idea

                        0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • Preserve indentation of multiple-line comment blocks

                        In SQL Prompt 8, multiple-line comment blocks (surrounded by /* */) are automatically indented to the SQL code surrounding them when formatting.

                        Can you please add an option to preserve the indentation of these blocks? My team keeps most comment blocks left-aligned for consistency and readability, but SQL Prompt will automatically move them when formatting.

                        This was not an issue in SQL Prompt 7, so all of our comment blocks are now moving when upgrading to SQL Prompt 8 and there is no option to preserve them. Thank you.

                        3 votes
                        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)

                          We’ll send you updates on this idea

                          0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                        • preserve indentation

                          When formatting a section of code, the indentation level should be preserved. e.g. Before

                          IF 1 = 1 BEGIN
                          -- I guess 1 = 1
                          SELECT 1 AS One;
                          -- I guess 1 = 1
                          END;

                          After:

                          IF 1 = 1 BEGIN
                          -- I guess 1 = 1
                          SELECT 1 AS One;
                          -- I guess 1 = 1
                          END;

                          The second comment is dedented. Since it is inside the begin/end block, it should use the same indentation level as the preceding statement (the SELECT)

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

                            We’ll send you updates on this idea

                            1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                          • Turn On/Off "Apply Formatting" via Toolbar or Keyboard Shortcut

                            I use SQL Prompt formatting to do things like add square brackets, apply casing options, insert semicolons, and qualify objects. But I sometimes do not want to apply the style layout to the document.

                            For example: A complex stored procedure that would be less readable if any (currently configurable) automatic layout. The procedure will be more maintainable and fit organizational guidelines to have square brackets added.

                            There is a keyboard shortcut and a toolbar option to remove square brackets. But not to add them.

                            Suggestion: Add Toolbar or Keyboard Shortcut for all the "Actions: When you run Format SQL, SQL…

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

                              We’ll send you updates on this idea

                              0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                            • Suggest main statement aliases inside APPLY clause

                              when inside an APPLY statement, the aliases from the outer query should be available for adding to the WHERE clause inside the APPLY.

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

                                We’ll send you updates on this idea

                                0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                              • Make sub-query table aliases ignore the "Align aliases" option in "SQL Prompt - Formatting styles" > "Global" > "Lists"

                                -- formatting so far
                                SELECT
                                *
                                FROM (
                                SELECT
                                [ID] = [AliasT].[ID]
                                , [Col2] = [AliasT].[Col2]
                                , [Col3] = [AliasT2].[Col1]
                                FROM [dbo].[table1] [AliasT]
                                LEFT JOIN [dbo].[table2] [AliasT2] ON [AliasT2].[ID] = [AliasT].[ID]
                                ) /*This is aligned*/ [Sub]
                                LEFT JOIN [dbo].[table3] [AliasT3] ON [AliasT3].[ID] = [Sub].[Col1];

                                -- sub-query table alias ignoring alias alignment
                                SELECT
                                *
                                FROM (
                                SELECT
                                [ID] = [AliasT].[ID]
                                , [Col2] = [AliasT].[Col2]
                                , [Col3] = [AliasT2].[Col1]
                                FROM [dbo].[table1] [AliasT]
                                LEFT JOIN [dbo].[table2] [AliasT2] ON [AliasT2].[ID] = [AliasT].[ID]
                                ) [Sub] -- this should not be aligned
                                LEFT JOIN [dbo].[table3] [AliasT3] ON [AliasT3].[ID] = [Sub].[Col1];

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

                                  We’ll send you updates on this idea

                                  0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                • An extension of the inline exec functionality to hard code the parameter variable values

                                  Instead of declaring and assigning the proc parameter variable values, substitute all references to the parameters with the hardcoded values.

                                  This will allow the proc to be run in chunks for debugging purposes without having to manually perform the substitutions.

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

                                    We’ll send you updates on this idea

                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add another column alias option "Column [ColumnAlias]"

                                    I would like another column alias option that will reformat aliases to:

                                    "Column [ColumnAlias]"

                                    4 votes
                                    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)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Since a recent update, SmartRename produces much longer scripts. Could it be shorter with an option ?

                                      Renaming a column causes a lot of procedures to recompile though there are no changes in their script. It was not the case before. I wonder if it is caused by a new handling of dependencies.

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

                                        We’ll send you updates on this idea

                                        0 comments  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Highlight columns in CTE

                                        It would be nice to find appropriate column position with CTE alias. For example:
                                        WITH cte_name (
                                        col1,
                                        col2,
                                        col3) AS
                                        (
                                        SELECT col1,
                                        col2,
                                        col3
                                        )
                                        If I click on col3 column in the SELECT statement, the col3 in CTE columns list is supposed to be highlighted and vice versa.

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

                                          We’ll send you updates on this idea

                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Auto add servers to Tab colouring

                                          It would be good to have an option to auto add all detectable servers to the Tab Color options page. I quite like to have every server with a different colour but adding them all individually is very time consuming.

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

                                            We’ll send you updates on this idea

                                            0 comments  ·  Tab coloring  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 36 37
                                          • Don't see your idea?

                                          Feedback and Knowledge Base