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. 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…

    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 semi-colon optional at END(;)

      Semi-colons are automatically added at every END reserved key word. Make this optional.

      END(;)
      END TRY(;)
      END CATCH(;)

      This just look weird to everyone

      BEGIN
      ....
      END(;) <=== don't want it here... there's an ELSE continuation.
      ELSE
      BEGIN
      END(;)

      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 →
      • Ability to format SQL text externally

        It would be nice to have ability to format the documents automatically, have an API or command line command for that. For example to force format when check-in code.

        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 →
        • Do not consider code flagged for no formatting when formatting.

          If I have a very large script with the majority of it with formatting disabled, or even with just a highlighted small area... the ctrl-K,ctrl-Y formatting seems to consider the parts it will not be formatting. Example: code in a separate window will format instantly while in a window with 100k lines with same code highlighted it will take a long while. This seems to indicate that it is considering all of the code even though it is only formatting a small piece.

          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 →
          • Add the name and description of a snippet (as a comment)

            When inserting from a code snippet, add the name and description of the snippet (as a comment).

            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 →
            • FORMATMESSAGE with automatic message IDs

              If we are typing a FORMATMESSAGE or a RAISERROR and our messages are precodified with numbers, it would be nice to get a list for messages with an small listbox to search the message by some text and get the number of the message with a comment inserted into the prior line.

              Before:

              SET @msg=FORMATMESSAGE(N'excee',....

              After search by the word "%excee%" and with an intelissense combobox... we get:

              --IDMsg 02938:"%s - ERROR: Limit exceeded for %s"
              SET @Msg=FORMATMESSAGE(02938,N'velocity');

              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 →
              • Max formatting

                When formatting SQL consider max part of the datatype rather than a reserved keyword when used with (n)varchar.

                I'd like to achive this formatting:
                SELECT CONVERT(varchar(max), 1)
                SELECT MAX(Column) FROM X

                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 →
                • Support field names from OPeNROWSET

                  When you have a regular table it will give you suggestions for the desire field automatically. It does not do t his with OPENROWSET tables.

                  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 →
                  • Management Studio 18.0 Support

                    SSMS 18.0 support, the latest till now, doesn't support ssms 18 preview 4

                    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 →
                    • Autocomplete WHERE clauses with variables

                      It would be neat if WHERE clauses could get autocomplete suggestions with declared variables (or variables that are procedure parameters). Example:

                      Assume Table1 with one column Column1.

                      DECLARE @Column1
                      SELECT *
                      FROM Table1 T
                      WHERE T.Column1 = (suggest @Column1, any variable that exactly matches column by name, except @)

                      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 →
                      • Automatic Alias from Table Name

                        (5 previous votes)

                        Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.

                        eg.

                        Customer = C
                        mem_Membership = M

                        cus_StateCustomer = SC

                        aReallyLongTableName = RLTN

                        view_CustomerMembership = CM

                        https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1931235-automatic-alias-from-table-name

                        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 →
                        • AND keyword for WHERE and JOINs on new line

                          There is no option in CLAUSES > JOIN to place AND on new line (Right aligned to INNER) and in Data (DML) there isn't an option to put AND on new line. Lots of tables I join on I am joining on 2 columns and I prefer to have the AND a.col1 = b.col1 on a new line as well.

                          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 →
                          • delete alias in CROSS APPLY function

                            I send a text of the other personne because my english is so bad.
                            Me and my colleague have the same problem(28 September 2018).
                            It's write by Ngainer at the August 29, 2018 2:07PM
                            Link : https://forum.red-gate.com/discussion/83138/the-latest-stable-build-of-sql-prompt-is-9-2-9-6459-13th-september

                            I am seeing an issue when a column from a table is passed into a Table-valued function. The alias for the table is being removed from the column. This causes issues if there are multiple tables with the same column name. An error is generated saying the "the column name is ambiguous". Is there a way to not remove the table alias 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

                              0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                            • move options settable under "SSMS > SQL Prompt > Options > Format > Style" page out of the Settings file and [back] into Style file

                              In version 7 the Style option FormatActionRemoveSquareBrackets was removed from the .sqlpromptstyle Style file into the .settings Settings file. I would like it moved back into the Style file, along with all other Style options settable under "SSMS > SQL Prompt > Options > Format > Style". See https://productsupport.red-gate.com/hc/en-us/requests/122489 for additional details.

                              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 →
                              • Support SQL Prompt in Visual Studio Code Review

                                When doing code reviews in Visual Studio Team Explorer, I want to be able to use SQL Prompt's Code Analysis to check the pull request or shelf set. At the moment that doesn't work, according to the SQL Prompt Dev team as of 27 Sep 2018:

                                Tianjiao Li (Support)
                                Sep 27, 15:26 BST

                                "Our development team has confirmed we do not currently support the Code Review feature in Visual Studio. SQL Prompt is not aware of this tab, so defaults to showing issues for the last SQL file it recognized. Whilst this behavior might seem a little strange, Code Review…

                                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  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                                • Short cut for comment\uncomment out a block \**\

                                  comment out selected text is used often. We will really appriciate that if you add a short cut for block comment. e.g MS SQL Serve has natively line comment short cut (ctrl+k, ctrl+c) uncomment (ctrl + k, ctrl+u), so something similar for (\**\)

                                  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 →
                                  • Script Temporary Table Declaration from Query

                                    Context menu item to take the current query under the cursor and script out an appropriate DECLARE @table or CREATE TABLE #table to match the names and types output from the query.

                                    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 →
                                    • T4 Integration, Scaffolding and Community Reuse Library

                                      Would be nice to have T4 integration so not only can you Create/Scaffold the CRUD stored procedures, but you can create the C# DTO classes, and the Repository class to Fetch one or many, Update,Save,Delete. As well as create the classes for the WebAPI. This would be useful for both WCF/WebAPI user but also for the BreezeJS users. Since T4 is the under pinning of MVC features you could utilise it in Prompt. If you looked at Codesmith Generator you can see their ecosystem of frameworks (http://www.codesmithtools.com/product/frameworks) which Red-Gate could have in its community reuse library.

                                      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 →
                                      • SAVE As JSON - Import from JSON - JSON is the new world order

                                        Just as you have save as Excel, Saving to JSON file is needed as sometimes you run out of Memory, or if you use PRINT it gets truncated. And if you use Algolia Search they will ask for a JSON file of your data. The is No Save to JSON file. There is no import from JSON.
                                        JSON is the new world order and SQL is so last week.
                                        SQL in on your legacy system and you have to connect to new JSON systems. Initially as copying Schemes over, for DTOs, Then bulk import to the new Mongo database or…

                                        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  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Add a pause button.

                                          It would be nice to be able to turn off SQL Prompt for short periods of time, maybe 1, 2 or 5 minutes. For example, I sometimes need to enter a list of email addresses as the basis of a query. I enter the opening quote and separating commas sung clrl+alt+drag. When I then add the closing quotes SQL prompt adds the second quote every other time.

                                          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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 41 42
                                          • Don't see your idea?

                                          Feedback and Knowledge Base