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. Results show table origin

    In the Results pane, prefix the column titles with the objects origin table/view etc. This helps when multiple objects have the same column name.

    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 →
    • Show object creation date

      When viewing an objects definition popup window, under the Summary tab, include objects Creation Date as seen in Object Explorer Details in SSMS

      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 →
      • Surround with ReSharper style

        Hi, a quite useful feature would be "surround with" similar to ReSharper. There's a similar feature available at the moment but quite limited e.g. in particular could not surround with brackes etc. and probably have a configurable shortcut e.g. Alt+Enter instead Ctrl
        Great product otherwise! I've been a happy user for many years.
        Thanks
        Pavel
        Thanks

        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 →
        • Table Data Preview

          When I hover over a table name, and I can see the script, as well as a summary including data types - I'd also like to be able to see a preview of the table's data. I understand temporary tables wouldn't be able to do this. It would save me the time of writing a select statement to view the top 50 rows.

          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 →
          • Enhance "Find Unused Variables and Parameters" to look for unused JOINs, too.

            Would be nice if this option (or a new one) highlighted JOINs that are not used elsewhere in the query. As applications evolve or new ones added, desired information may shift to a new table, and the old column retained for legacy purposes. When we revise a procedure to use the new information instead, the old JOIN may become unnecessary, and "housekeeping" to clean these up can cause problems in large queries if not done carefully. Would be acceptable if use of this feature required the use of table aliases, if that would make it easier to implement.

            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  ·  Find unused variables  ·  Flag idea as inappropriate…  ·  Admin →
            • Add "closed tabs" to the tab history

              Add a "closed tabs" list to the tab history - that's usually what I use it for rather than open tabs, which I try to keep to a minimum. That said it makes it hard when there are a dozen tabs all called "SQLQuery1", "SQLQuery2" to know which are open and which are closed...

              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 →
              • Introduce variable declaration for scalar values

                It would be great if the new menu in SQL Prompt 7 included an option to DECLARE all scalar values in selected text as variables!!

                So that

                " select a from b where b.c = '5' "

                would become

                "
                DECLARE b_c AS NVARCHAR(?) = '5'

                select a from b where b.c = b_c"

                ex.

                "
                Declare

                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 →
                • Have the reverse of 'encapuslate as sp'

                  Sometimes when debugging a large lengthy stored procedure, I need to break the code down into logical chunks, adding output and adding temporary, intermediate result sets.

                  I start off by taking the stored procedure, stripping away the header and creating declare local variable statements to replace the parameter list. Then adding SET statements to set the values.

                  This seems like the kind of thing that could be automated, and hence added into SQL Prompt

                  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  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
                  • Create Blocks, align join conditions (not beginning of lines), indent select items

                    Create blocks of text by adding space before the keywords following keywords (Select, Join (all types), Where, Group By, Order By, Having), align the conditions of joins so that they are like a list. Here is an example

                    Union All

                    Select
                    a.App_Sys as LOB
                    , a.Bnk as Bank
                    , a.Center as Center
                    , Count( a.App_Sys ) as MissingComboCount
                    , Avg( a.Avrg_Mo_Blnc) as AverageAvgMoBal
                    , Min( a.Avrg_Mo_Blnc) as MinimumAvgMoBal
                    , Max( a.Avrg_Mo_Blnc) as MaximumAvgMoBal
                    , Sum( a.Avrg_Mo_Blnc) as TotalAvgMoBal
                    , @dateProc as dateProc
                    , getdate() as dateCreate
                    , a.Center + '-' + a.Bnk as CenterBnk
                    From
                    anc.rptCore40BlsCurMnth as a

                    Left Outer…

                    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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow the option for SQL formatting of nested inner join on an outer join to indent the nested inner join.

                        When you have a nested inner join to an outer join, such as:

                        SELECT a.*, b.*, c.*
                        FROM
                        A a
                        LEFT JOIN B b
                        INNER JOIN C c on b.b_id = c.b_id
                        ON a.a_id = b.a_id

                        It should allow an option to indent the nested join further to show that it is nested

                        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 →
                        • Table Split procedure updates failure

                          If you do a Split Table and try to create a new table in a different schema but with the same name (eg. Split Table on Schema1.Employee -> Schema2.Employee) ends up generating the same alias for both tables in updates to procedures, and fails. Including some schema reference in the alias name for the tables in procedure updates seems like it would fix this).

                          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  ·  Split table  ·  Flag idea as inappropriate…  ·  Admin →
                          • Automatically generate variables for select statements

                            I pull SSRS queries over into SSMS 2014 all the time and get annoyed at having to comment out or declare the variables in the select.

                            Example:

                            SELECT * FROM Manufacturing
                            WHERE ItemID = @ItemID
                            AND TransactionDate BETWEEN @StartDate AND @EndDate

                            Can something be created to scan the select and write out the declarations?

                            DECLARE @ItemID dynamic? = '', @StartDate dynamic? = '', etc..

                            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 →
                            • Allow autocomplete of FROM with white space after SELECT

                              When typing a SELECT statement do not require columns before suggesting keyword FROM.

                              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…)
                                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • Allow a comparison to be run on scripts in two different tabs within SSMS

                                As an example, if I have a script for a stored procedure in one tab and a proposed modification to that procedure in another tab then a comparison (like SQL Compare) would show be the differences.

                                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 →
                                • Change suggestions for replication and change tracking objects

                                  Either remove replication and changing tracking objects from the suggestions or reorder the suggestions so they are no longer suggested before other objects.

                                  9 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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Propagate smart-rename through foreign key hierarchy

                                    For example, if table Person has Person_ID, and table Employee also has Person_ID which has a foreign key relationship to Person.Person_ID, then I smart-rename Person.Person_ID, it would be spectacular if Employee.Person_ID was also similarly renamed.

                                    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 →
                                    • Formatting profile compatible with sqlstyle.guide

                                      I wondered if it would be of interest to add an auto formatting profile in line with http://www.sqlstyle.guide

                                      It is a SQL code style guide that I published recently.

                                      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…)
                                        2 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                      • prevent Prompt SQL from destroying bookmarks

                                        If format SQL makes chnages - it destroy saved marks
                                        This occurs even when line bookmarked line hasnt (visibly) changed
                                        Very frushtrating

                                        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 →
                                        • Ability to filter columns in invalid object list

                                          Ability to filter columns in invalid object list

                                          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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 20 21
                                          • Don't see your idea?

                                          Feedback and Knowledge Base