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 https://forum.red-gate.com/categories/sql-prompt

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. Format SQL : Add blank line at end of script

    Can you add an option to add a blank line at the end of a script, when formatting? This would help when concatenating scripts together.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    • Convert selected SQL to EXEC statement

      This is to convert existing SQL staement(s) to an EXEC statement, including applying quote escaping as required.
      A smart version would use EXEX sp_executesql if the selected SQL statements contained variable refreneces, allowing this to work for both trivial case, and the not-so-trivial case.

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Find Invali

        Be able to search for invalid objects inside jobs

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
        • Option to have the results 'Script as Insert' use SELECT statements instead of values

          If easy to implement have the option to have the results 'Script as Insert' use SELECT statements (with UNION ALL between them) instead of VALUES (vals),(vals),etc. SELECT causes much less logging, "You can use INSERT INTO <target_table> SELECT <columns> FROM <source_table> to efficiently transfer a large number of rows from one table, such as a staging table, to another table with minimal logging. Minimal logging can improve the performance of the statement and reduce the possibility of the operation filling the available transaction log space during the transaction." -- https://docs.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql (Under best practices)

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
          • Have the update process default to only updating installed tools

            I don't use SQL Prompt in Visual Studio and likely never will. However, every time I update, the updater defaults to installing it for VS and updating SSMS. It would be nice if the update process defaulted to only doing updates.

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
            • Need a hotkey for toggling between "one on a line" to "all on one line" for any selected comma delimited list.

              A hotkey for toggling between "one on a line" to "all on one line" for any selected comma delimited list.

              Allowing us to assign hotkeys for styles would accomplish this, most of the time but for speed I don't want to have to mouse around, I want to make the selection with my mouse and issue by pressing a hotkey.

              I often need to change between this format for development:
              INSERT INTO zts_dev_coco_20180410.dbo.Zo_MiniOz12
              ( GridCode
              , RowOrd
              , RowCodeBase
              , Partition
              , RowText
              )
              SELECT
              GridCode
              , RowOrd
              , RowCodeBase = 'newbase'
              , Partition
              , RowText = 'New gazelle'
              FROM…

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
              • Add rule for deprecated DATABASEPROPERTY

                Add rule for deprecated DATABASEPROPERTY

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                • "Script as INSERT" should respect "Insert full INSERT statement" setting

                  The new "Script as INSERT" feature generates scripts that do not include a column list. The generated script should include a column list if the "Insert full INSERT statement" setting is checked.

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                  • Put single quote marks around highlighted text (including multiple lines)

                    Very often i have copied a list of items i want to query in an IN() statement from the database, for example:

                    abc
                    def
                    ghi
                    jkl

                    and I want to format it like this:

                    'abc'
                    'def'
                    'ghi'
                    'jkl'

                    or better yet:

                    'abc'
                    , 'def'
                    , 'ghi'
                    , 'jkl'

                    Being able to highlight, right click, and select an option do do this, would be incredibly helpful.

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      3 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                    • Change curly quotes to straight quotes

                      When pasting SQL from emails, web sites, etc. there are often curly quotes. It would be nice to have those replaced with straight quotes instead of manually replacing each one.

                      See:
                      https://practicaltypography.com/straight-and-curly-quotes.html

                      0 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                      • Hotkey to join current line with next

                        This is simply to address what I consider a missing hotkey from SSMS / Visual Studio.
                        It really is as simple as joining the current line with next, replacing all whitespace from the end of this line and the start of the next line with a single space.
                        The motivation in the context of SQL Prompt is to "undo" some formatting changes that I would prefer not to have.

                        As a future step, some intelligent wrapping options with the hotkey would be great.

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • backup devices

                          backup device

                          I would like to see backup devices added to intellisence.

                          Example

                          If I key

                          Backup database [name] to ....

                          I would like to see a list of backup devices in intellisense drop down.

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                          • Conditionally place ON keyword on new line if exceeds specified wrap margin

                            My default preference is to maintain the ON keyword without a new line. I would like to be able to CONDITIONALLY place the ON keyword on a new line if, and only if the ON keyword together with the associated ON condition exceed a configurable wrap threshold.

                            Example:
                            -- Yield this >>>>
                            SELECT *
                            FROM Person.Address
                            INNER JOIN Person.StateProvince
                            ON StateProvince.StateProvinceID=Address.StateProvinceID
                            -- >>>> instead of

                            SELECT *
                            FROM Person.Address
                            INNER JOIN Person.StateProvince ON StateProvince.StateProvinceID=Address.StateProvinceID
                            -- Assuming the JOIN clause exceeds the wrap length
                            -- <<<

                            This is particularly useful if the "Place JOIN table on new line" is NOT selected…

                            1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                            • "only if table expression" option for Place JOIN table on new line

                              My preference is to not select "Place JOIN table on new line" option. However, if the JOIN target is an SELECT expression, it quickly becomes difficult to follow. The JOIN with SELECT expression is much better suited to have the "Place JOIN table on a new line"

                              The idea is to have a "Only if JOIN Expression" sub-option for "Place JOIN on new line" to allow best of both worlds.

                              Example:

                              --- >>>> BEGIN EXAMPLE
                              SELECT TOP (10) *
                              FROM dbo.Player AS p
                              INNER JOIN
                              (
                              SELECT c.CountryCode, c.Name, c.A2, c.A3
                              FROM dbo.Country AS c
                              WHERE c.IsValid<>0
                              ) AS c…

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                              • Show parameters names and their types when hit ctrl+space inside the brackets

                                Let's take following example.
                                SELECT * from dbo.some_function()

                                If I hit ctrl+space when my cursor is here:
                                SELECT * FROM dbo.some_function$CURSOR$() then I am getting function definition and that's OK.

                                If I hit ctrl+space here:
                                SELECT * FROM dbo.some_funnction($CURSOR$) I am getting nothing useful. I suggest to show what are the parameters for that function with their data types.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                                • Link server problem

                                  In sqlserver, if the link server is used, when the link server is not available, all databases are not intelligent.

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Remove redundant parentheses

                                    I sometimes get code that looks like this:
                                    WHERE (a = b) AND (c = d) AND (e = f)

                                    Or even like this:
                                    WHERE (((a = b) AND (c = d)) AND (e = f))

                                    It would be great if SQL Prompt would have an option to remove all the redundant parentheses and reduce this to
                                    WHERE a = b AND c = d AND e = f

                                    Of course it would have to be smart enough to not remove parentheses that are needed when mixing AND and OR. So if I submit this code:
                                    WHERE ((a = b)…

                                    2 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Feature Suggestion List, Sort Search Results

                                      This suggestion is for your feature suggestion list web pages. When I search your site to see if someone has already suggested something similar to what I am about to post, I would like to sort the results by most similar (this seems to be the default) OR by most popular (so I can bump up the vote if the suggestion matches mine).

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Formatting Style Suggestion

                                        Some suggestions for formatting options; the options needed to create this format are all there in some form but are not combined or available in a way that make it possible today.

                                        • Align "when" and "condition" to tab for case statements
                                        • New line for "then" when "condition" is longer than some limit for case statements
                                        • New line after last statement in select list
                                        • New line after "left" and “outer” in join clause
                                        • New line after “cross” in cross apply and cross join
                                        • Align "and" to statement in join clause BUT align “and” to first…

                                        3 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

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

                                          Others languages. Is it possible to?

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 40 41
                                          • Don't see your idea?

                                          Feedback and Knowledge Base