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. Defer tab connection until it is opened

    I tend to have lots and lots of tabs open, both in SSMS and my browsers. Firefox has a very good option to only load a tab once I click it.

    Would be great if SQL Prompt would do the same, waiting for it to restore connections for 20+ tabs is quite frustrating when you are in a hurry.

    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 →
    • Add OUTPUT parameters when executing a stored procedure

      When inserting code to execute a stored procedure, SQL Prompt currently automatically generates input variables of the correct data type, e.g.:

      EXECUTE ETL.spLoad_DimPerson
      @LatestLoadDate = '2016-06-21 18:51:43', -- datetime2
      @TargetRowsInserted = 0, -- int
      @TargetRowsUpdated = 0, -- int
      @TargetRowsDeleted = 0 -- int

      However, the syntax does not seem to recognize OUTPUT parameters. When I ask SSMS to generate a query for me by right-clicking and choosing 'Execute stored procedure...', it gives me the following:

      DECLARE @return_value int,
      @TargetRowsInserted int,
      @TargetRowsUpdated int,
      @TargetRowsDeleted int

      EXEC @return_value = [ETL].[spLoad_DimPerson]
      @LatestLoadDate = '2005-06-21 18:41:59',
      @TargetRowsInserted = @TargetRowsInserted OUTPUT,
      @TargetRowsUpdated = @TargetRowsUpdated…

      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  ·  Flag idea as inappropriate…  ·  Admin →
      • prevent undocumented keywords from coming up as aliases

        Right now SQL Prompt will avoid auto-generating a keyword as an alias, such as in the following example:

        DECLARE @AlphabetSoup TABLE (x INT)
        SELECT * FROM @AlphabetSoup aso -- extra "o" to avoid "as"

        However, I've run into a couple of undocumented "keywords" that SQL Prompt doesn't exclude:

        DECLARE @AlphabetSoup TABLE (x INT)
        DECLARE @ReasonableColumn TABLE (y INT)
        DECLARE @RidiculousColumn TABLE (z INT)
        SELECT * FROM @AlphabetSoup aso CROSS JOIN @ReasonableColumn rc CROSS JOIN @RidiculousColumn rc2

        For whatever reason, rc2 (along with rc4, see http://dba.stackexchange.com/questions/22655/why-is-lookup-colored-as-a-function-reserved-word-in-sql-server/22661) is coming up as a reserved keyword. Can SQL Prompt avoid generating this as…

        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 →
        • sp_configure to make suggestions similar to serverproperty

          When writing queries that run "sp_configure", it would be helpful if the various configuration options were offered in a dropdown - much the same way that happens when writing a "select serverproperty" query.

          For bonus points - highlight the state of Show Advanced Options at the top of the list, so we can see what's currently available vs what could be available.

          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 →
          • Create Declare and Set Statements

            Many tmes I'll paste a SQL statement from a stored proc into a script so I can manually run the query to see the results.

            It'd be nice if there was an option from SQL prompt to scan the SQL and find the parameters used in the query and add DECLARE and SET statements at the top,

            It could evaluate where the parameters are being used and determine their datatype for the DECLARE and some default value in the SET statements.

            6 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 →
            • change connect of tab

              I dont know if its possible, but it would be awesome if you could right click on a tab and change the connection on the fly. I have used this feature in other IDE and its helpful when query between TEST and Prod without having to re-connect.

              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 →
              • Improve the new rename variable feature

                Instead of having to select the "rename variable/alias" in the context menu, how about auto-detecting that a variable has been changed and prompt the user or flag the user for some input to update all usages of the variable. I envision this happening when changing the variable name at the DECLARE statement. Perhaps a shortcut key would force the rename as well. I think in VS when a variable is changed, it flags it and wait for the user to give some sort of queue for it to rename all instances of the variable with the new 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  ·  Flag idea as inappropriate…  ·  Admin →
                • Ability to call "find invalid objects" from T-SQL

                  Our organization would like to have a report of invalid database objects. SQL prompt has this functionality built in but I'd like to call this feature from T-SQL and display the results on a report.

                  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 →
                  • Ability to generate SELECT test script from an UPDATE statement

                    When debugging an UPDATE statement, it would be handy if SQL Prompt could generate a test Select script that converts

                    UPDATE xxxxxx
                    SET SalesPeriod = dddddd,
                    SalesYear = yyyy,
                    CustomerCode = zzzzz
                    ...

                    into

                    SELECT dddddd as SalesPeriod,
                    yyyy as SalesYear,
                    zzzzz as CustomerCode
                    ....

                    Optionally, could include all columns involved in joins or WHERE clauses

                    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 →
                    • multiple "Workspace"

                      Allow the current tabs to be saved (and then reloaded). Having multiple Workspaces like this would be of great benefi

                      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 →
                      • Prevent excessive caching

                        My database server has over 250 databases and sometimes i need to run a query against all of them. The app tries to load/cache all of those databases which takes a long time and some times causes SSMS to crash. Can you add a feature that detects this and asks if you really want to load all those databases.

                        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…)
                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                        • smart rename

                          My suggestion is to add support for Smart Rename of a database. It would update objects (procedures, views, functions, etc) that reference fully qualified objects. This would be very handy when database name changes due to new naming standards or other reasons.

                          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  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                          • Colorize same TEXT like Notepad++

                            colorize same structures in a user-defined Color like "green"
                            e.g. IF, Select, ...

                            IF
                            Begin
                            ...
                            End

                            IF

                            ...

                            colorize same Text,
                            e.g. for faster recognize variable

                            Declare @Test int

                            @Test = "BlaBla"

                            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 →
                            • exclude comments from "start new line at Boolean operator"

                              I frequently mark up JOIN and WHERE conditions with comments indicating why I am filtering them, like in the following:

                              SELECT TABLE_NAME
                              FROM INFORMATION_SCHEMA.COLUMNS
                              WHERE
                              1=1 AND --stay put!
                              2=2

                              However, when the "start new line at Boolean Operator" is enabled under Format > Expressions, SQL Prompt will place the comment on a new line after the condition:

                              SELECT
                              COLUMNS.TABLE_NAME
                              FROM
                              INFORMATION_SCHEMA.COLUMNS
                              WHERE
                              1 = 1 AND
                              --stay put!
                              2 = 2

                              Can this be configured to allow comments to stay where they are, even when the "start new line at Boolean operator" option is enabled?

                              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 →
                              • Smart Rename via Synonym

                                Being able to have Smart Rename also generate a synonym of the old name, pointing to the object with the new name, would be very useful in scenarios where there is external code pointing to specific database objects that you're renaming.

                                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 →
                                • Show part of the sql text on the tabs hint

                                  You could show at the tab hint, the first lines of the query typed on that tab. It'll help a lot to localize a especifi query among a lot of tabs opened.

                                  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 coloring  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Execute current statment

                                    Shift-F5 is great but I think this change could make it better.
                                    Before I discovered Shift-F5 and when I had multiple sql statements in my window, I would select the block of sql I wanted and hit F5 to just execute that code block. Then I discovered Shift-F5 and I no longer had to select my sql block it was done for me - but what it doesn't do is actually select the code block, instead it just highlights it in green and executes it. So if you just do an F5 (out of habit) after a Shift-F5 it won't…

                                    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  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Configurable Execution Warnings

                                      The new Execution Warnings functionality to warn of UPDATE or DELETE statements without a WHERE clause is great; however, the warning triggers even when the code is in the definition of a Stored Procedure.

                                      It would be good then to have advanced functionality to allow for us to be able to select whether to warn on SP definition text, or to turn on the warnings when running against temporary tables.

                                      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  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Auto-Close of /* should be --*/

                                        Add an option to allow /* to be auto-closed with --*/ rather than just */.
                                        There are a long list of ways that using this syntax allows coding of more easily tested statements and, in general, making troubleshooting of complex procedures easier. At the same time turning it on doesn't hinder normal comment use in any way so there are no real drawbacks to making it your default.

                                        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 →
                                        • Update a column name if I add or change an alias in a CTE

                                          For example:

                                          WITH x AS (SELECT 1 AS ColName)
                                          SELECT x.ColName
                                          FROM x

                                          If I change the ColName alias in the CTE, the outer select will become invalid. Perhaps this could be an extension of the F2-rename feature.

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

                                          Feedback and Knowledge Base