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. Generate Scripts Based on the Result Grid

    Just like in Toad and SSMSBoost, there's a facility to create a script such as INSERT based from the given result grid. This would be handy in generating test data or re-populating tables

    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…)
      1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
    • Creation of Folders for Tables and Stored Procedures

      It would be great, if I could create custom folders in the SSMS to organize hundreds of tables, stored procedures, views ...

      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…)
        1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
      • Display foreign key relationships graphically inside the script and summary window

        When coding delete queries it would be useful if there would be a graphically representation of the foreign key relationships of the object you are deleting on.

        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 →
        • Link users to a github repo of snippets where they can clone/contribute/fork as they desire: https://github.com/gvohra/sqlpromptsnippets

          A lot of users are asking for more snippets, or ways to share snippets with teams. How about linking people to a public repo on github where they can clone/contribute/fork as they like?

          I've just set one up here which has all the Red Gate defaults, plus about 50 key others I have added (like gb = GROUP BY):

          https://github.com/gvohra/sqlpromptsnippets

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

            It would be nice to have a TRY CATCH snippet.

            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 →
            • I would like to be able to manager 'tab magic' feature, like dont save the last couple years, or filter it to x monthes, days, etc

              implement filter and or manager of tab history. like show the last 2 months or days or whatever. The Manager I could just delete or removed outdated items. I have been using tab history since day 1. when I run it, I feel I have an pulling up too much for program to handle. it takes too long now

              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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
              • SYSDATETIME() instead of GETDATE() as default value for datetime2 columns

                When generating an insert script with default values for a table, use SYSDATETIME() instead of GETDATE() for datetime2 columns. GETDATE(), is fine for datetime columns, but for datetime2 columns, which have a larger precision SYSDATETIME() would be more appropriate.

                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 →
                • Allow Multiple Snippet Folders

                  Hi, I think it would be useful to add support for multiple snippet folders to the SQL Prompt - Snippet Manager. I would use this by connecting to a set share of snippets that our team uses as well as having my own set of snippets that may be useful only to me.

                  Thanks for considering,
                  James

                  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  ·  Flag idea as inappropriate…  ·  Admin →
                  • when clicking a table currently we see table structure and columns, please display primary keys

                    when clicking a table currently we see table structure and columns, please display primary keys and foreign keys that are in this table along with 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                    • Sort suggestions by closest match

                      What I mean by closest match varies between match types. In the case for camel case (or underscore-separated first letter matching), the closest match would be the one that has the exact initials. Next closest would be ones with additional suffixes, those with prefixes, and then those with intervening content between matched initials. Somewhere in there should be any matches with the search value as a direct substring. For the case of substring matches, an exact match should be first, then matches closest to the beginning of the name should be listed next, sorted by suffix length (or alphabetical for…

                      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 →
                      • Use icon to denote fields with indexes

                        When the drop down appears with field names (like when you're typing in a WHERE clause), include a little icon for each field that's the first field in an index (like the key pic when it's the PK).

                        Being able to say "oh, that one has an index" would help me when trying to figure out how I want to filter things. (aka use "inserted_time" vs "post_time" vs the "start_time"). I'd say to use one icon (maybe greyed out) for non-clustered, and a different (or not greyed-out) icon for the clustered. You already include the field size, so why not…

                        16 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 →
                        • Option to remove font smoothing in tab history

                          Due to eye problems I have to work without font smoothing - any type, be it grayscale or cleartype will give me a headache.

                          As such, the tab history - which is usually incredibly useful - I can only use for maybe a minute or two.

                          Can you build a way to change the look of the screen to remove the font smoothing?

                          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 →
                          • embedd any of the existing sql prompts short cuts within a snippet

                            I have an sql template that I am have assigned to a snippet which allows me to create standard stored procedures straight from MSSQL management studio, works like a charm.
                            However I have a parameter of the template that asks for the main table being used.
                            <Table,,> which is replaced in the stored proc template with whatever the table name is.

                            Then inside the template have a simple select * from <table,,>
                            which when run as a snippet produces a line of code , select * from tablename.
                            What I would like to be able to do is utilise the…

                            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  ·  Flag idea as inappropriate…  ·  Admin →
                            • Extract a Table defintion from a SELECT ... INTO....

                              There have been many times when I've been working with a procedure that has one or more SELECT ... INTO, usually to create a temp table.

                              If I want a CREATE TABLE definition for the table created that way, I have to change the procedure to SELECT ... INTO a permanent table then script out the definition of the table.

                              It would be very helpful if SQLPrompt had a way to generate the CREATE TABLE statement from the SELECT ... INTO (even if the data types aren't perfectly correct)

                              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 →
                              • Put the snippet XML in comment block

                                Change the snippet file format so it's editable and runnable in Management Studio by putting the XML portion in a SQL comment block.

                                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 →
                                • semi colon placed on new line

                                  Place semi-colon on new line.

                                  I frequently format my statements as I'm developing them, but multiple times now I've started to add an Order By or some other clause after the auto-inserted semi-colon. I would like to see an option to place the semicolon on the line following the sql statement rather than directly after. This would enable me to start typing at the start of the next line without having to check if a semicolon had been added to the preceding line.

                                  Example:
                                  Select * From Table
                                  Where A = 1; -- Semicolon added by formatting
                                  Order By A

                                  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 →
                                  • Autocorrect for Missing * in select statements with no fields: Select top 10 from table-> select top 10 * from table

                                    Automatically fill in Missing * from select statements: For example:
                                    Select from table -> Select * from table
                                    Select top 100 from table-> Select top 100 * from table
                                    Select into table... you get the point.

                                    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 →
                                    • Exclude Identity Field From Auto Generated Insert/Values Code For Table Variables

                                      If a table variable or temp table has an identity field, I do not think this field should show up in the auto generated insert into/values list:

                                      DECLARE @Table TABLE (TableId INT IDENTITY(1,1), Data VARCHAR(100);

                                      INSERT INTO @Table
                                      ( [TableId] -- This field show not show up by default in the insert list
                                      , [Data] )
                                      VALUES ( 0 -- TableId - int -> This field show not show up by default in the insert values list
                                      , '' -- Data - varchar(100)
                                      )

                                      -- Temp Table
                                      CREATE TABLE #Temp (TableId INT IDENTITY(1,1), Data1);

                                      INSERT INTO [#Temp] ([TableId],
                                      [Data1]) VALUES…

                                      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…)
                                        2 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                      • in "summarize script", an "if" and its "else" should be on the same level

                                        This statement:

                                        IF condition
                                        ...
                                        ELSE
                                        ...

                                        is semantically equivalent to this pair of statements:

                                        IF condition
                                        ...
                                        IF NOT condition
                                        ...

                                        That's how I think of them. SSMS and SQL Prompt treat them that way; If I use SQL Prompt to format my SQL, and SSMS's "outline statements" feature to collapse regions of code, then an IF/ELSE statement looks like this:

                                        IF @I = 1
                                        [+] BEGIN [...];
                                        ELSE
                                        [+] BEGIN [...];

                                        The IF block and the ELSE block are treated as two separate IF statements with equal importance. The ELSE keyword lines up with the IF keyword, and…

                                        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  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Unwrap a view

                                          Sometimes I start using an existing view as base for a new SQL query. Often I end up like this:
                                          SELECT o.Id
                                          ,o..........
                                          ,e.name
                                          ,e.....
                                          FROM vOffice AS o
                                          LEFT JOIN Employee AS e ON o.Id = e.OfficeId

                                          When I end there, I would like an easy way to right-click vOffice-view and then let SQL-prompt "translate" the view back to its original table name(s) and joins.

                                          By doing this I can easily use the other columns that this view has not included - and create a new view that is not based on another view.

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

                                          Feedback and Knowledge Base