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. Add option in context menu to "Open In Browser"

    When the grid outputs a link as its value, right clicking the cell would provide an option to "Open In Browser"
    ...
    Additionally, this same functionality could be customizable (perhaps a customize context menu section within SQL Prompt options) to allow for other applications, wherein the highlighted/cell value is passed as a parameter to a given application. This would be similar to the External Tools, which is provided within SSMS, but having that option right there in the context menu would be gold.

    So, in the case of a URL, I right click the cell, choose Open In Browser, and…

    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 →
    • Allow importing of .settings file, and setting Code formatting/snippets folders and default formatting style to be done via Command line

      I would like to be able to better automate our onboarding process for new developers by helping ensure their snippets folder, formatting style folder and default formatting style are correctly setup. Additionally we would like to be able to automatically import settings from UNC/source control for them. This reduces the inevitability that something is missed when trying to follow a setup guide we have to additionally maintain. Thanks!

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

        I'd like to vote for adding ST008 (non-named parameter style used) to the issues which can be auto-fixed. Hopefully it would be fairly simple to implement.

        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 →
        • Use named parameters when encapsulating as new stored procedure

          It would be nice if the "Encapsulate as new stored procedure" logic used named parameter style so I don't immediately get ST008 in my code which calls the new proc.

          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  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
          • Don't allow for aliases that match snippet acronyms

            What I sometimes run into, is that a table gets an alias (by SQL prompt), that matches an acronym for a snippet. Then, whenever I'm writing out my query, while calling the table by alias, snippet manager replaces the alias with the full snippet. Which can be annoying as Ctrl-Z doesn't work.

            My suggestion would be to check the snippet manager before assigning aliases and not have them overlap.
            Thanks.

            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 →
            • Stop resetting defaults (like paths) with every Update

              I spent a lot of time setting up custom directories for various products/features and its frustrating how SQL Prompt resets this with each new update forcing me to go back and change all these paths/defaults back to what they were before.

              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 →
              • Prevent suggestions after typing a number

                It would be good to have an option to not offer suggestions after typing a number. If i'm about to enter a constant such as set @var = 1 I usually don't want to see suggestions containing 1. Often I have to turn suggestions off to type a number.

                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 →
                • Prevent suggestions after typing a single quote.

                  It would be good to have an option to not offer suggestions after typing a single quote. If i'm about to enter a text string I usually don't want to see suggestions. Often I have to turn suggestions off to type a quoted string.

                  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 →
                  • Be able to add space between two right parentheses

                    When I have two right parentheses next to each other like in a query like this (in the OPTION clause)
                    SELECT Columns
                    FROM TableA
                    INNER JOIN TableB
                    ON TableA.Key = TableB.Key
                    OPTION( USE HINT( N'FORCE_DEFAULT_CARDINALITY_ESTIMATION' ) )

                    There doesn't appear to be an option to have the space between the two right parentheses at the end. I have tried checking/unchecking quite a few boxes in the formatting style editor, and I don't think anything is controlling this. To me, the "add spaces around parentheses contents" option should put a space between the two right parentheses, but it doesn't.

                    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 →
                    • Vertical rivers - cobol style

                      When writing SQL I don't think procedurally, which means I don't think about nested, indented "blocks" unless I'm actually using some procedural style SQL extensions like try/catch, if, case (which is a little procedural expression inside a set based statement), and so on.

                      Because of this, I like to align various different "types of things" in a statement to create vertical rivers.

                      So, for example, insert, update, select, from, join, where, group by, having, and order by are all aligned on the left. You might think of this as "column 1 - sql keywords".

                      Then come column names, table names…

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

                        On SQL Prompt Aliases section I would like to have on custom aliases when I add a new a dropdown or a list view where I can pick object instead of me writing the object name. it would be even better if it has an option to show only object not already added with alias.

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

                          Have SonarQube plugin that will do code analysis using your rules rather than TSQL or PLSQL plugins

                          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  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                          • Automatically alias tables and columns in existing scripts

                            Please could you add a feature that parses a query that has already been written, adds aliases for tables that don't already have them and update columns to use those aliases.

                            This is because I often get pieces of code which are partially aliased and I have to go through updating the missing ones. Thanks.

                            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  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
                            • Allow custom rules for code analysis

                              SQL Prompt has the ability to catch and warn about Update statements without Where clauses.

                              How about something similar that catches and warns about security commands like Grant or Deny.

                              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  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                              • SSMS - object list - filter from clipboard

                                In the right-click menu of the "Tables" branch in SSMS, create an extra item that would retrieve string from system clipboard and apply it as an object name filter (using the SSMS built-in [Filter] => [Filter settings] => [Name] => [Contains] feature).

                                This would allow for instant filtering, saving lot of time.

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

                                  Please, separate options to align aliases for columns and tables..... I love aligned column aliases, but table aliases advance too far right, unnecessarily.

                                  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 →
                                  • Make Ctrl-Y repeat last action

                                    I use actions (from the ctrl menu) a lot. It would be extremely handy if I could re-do last action on the currently selected text by simply hitting Ctrl-Y (rather than hitting Ctrl and selecting it from the list of actions again and again).

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

                                      Similar to visual studio code, it would be good to have a find and replace all occurrences by highlighting what you would like to replace. This would then give you the option to type in what you want to replace. I know Sql Server has a find and replace function, however I just really like this functionality and think it would be a great addition to SQL prompt

                                      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 →
                                      • 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 →
                                        • More Casing/Capitalization Options

                                          Regardless of the source table, we would like the option to force table, column, and alias names to lower case. (We integrate databases from multiple sources and our queries look like a mess when half of the columns are upper case and half are lower).

                                          Example:
                                          SELECT dp.PROJ_ID AS cp_proj_id,
                                          pld.suffix AS project_segment,
                                          IP.project_number AS inn_proj_id
                                          FROM DEL.PROJ AS dp
                                          INNER JOIN DEL.view_project_lvl_detail AS pld
                                          ON pld.PROJ_ID = dp.proj_id
                                          LEFT OUTER JOIN inn.PROJ AS IP
                                          ON dp.PROJ_ID LIKE IP.cp_proj_id + '%'

                                          I think this is hard to read. We'd prefer the keywords to standout as uppercase and standardize all out…

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

                                          Feedback and Knowledge Base