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. Provide user feedback when Ctrl-F12 can't find the object because the server isn't open in the object explorer

    If the server isn't open in the object explorer then Ctrl-F12 can't select the object, but SQL Prompt doesn't provide any feedback to the user. This can be confusing as it could be down to SQL Prompt not refreshing, or suggestions being turned off.

    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 →
    • Enhancement to "Warning on delete and update statements if no WHERE clause is specified" (clarified)

      This is a clarification to an earlier post. (https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/13543761-enhancement-to-warning-on-delete-and-update-state)

      This is a great idea, but I was surprised by the number of "false positives" I am getting (and yes, I can just mute the messages completely).

      In my case I am doing a lot of updates/deletes on permanent tables with joins to temporary tables or table variables and that limits the update/delete scope.

      Can you add to this feature so that messages will not be emitted if there is a join to a temporary table or table variable?

      For example...
      Update dbo.RealTable
      Set SomeData = tt.SomeData
      From dbo.RealTable…

      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 →
      • Suggest the field when used the clause "isnull"

        Suggest the field when used the clause "isnull"
        for example when using the code:

        where person.autoid = isnull (@IdPerson, "person.autoid")

        To do that field in brackets be suggested, as is almost always used the same field that is in comparison.

        Excuse my english.

        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 →
        • CSV Export with Ecapsulation

          I really like the feature that enables the export of the result grid to Excel. But for big data sets it would be more useful to have a csv export that improves on Microsoft's i.e. supports encapsulation with double quotes "Data1","Data2","Data3" etc - this could be extended to permit the user to select a delimiter other than a comma, tab for example.

          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 →
          • Copy object script to New Query

            Copy object script to New Query

            When accessing an object's definition using the popup (which is accessed from the intellisense menu), it would be great if there was an additional button (next to the existing Copy button) which copied the contents of the object's script to a new query window.

            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 →
            • Intellisense support for hypens/dashes in table names

              When a table name contains a dash or hyphen "-" (i.e. dbo.Daily-Holdings), the intellisense stops working after you type the dash/hyphen

              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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
              • Sum selected columns

                It would be nice to have some capabilities that exist in Excel 2013. Specifically the feature when you can highlight a column and then at the bottom of the application it gives you some quick statistics for the column. So if I had a column of numbers, and I highlighted the column in the results pane it would give me the Average of the numbers in that column and the sum of the numbers in the column. If the column was text you could see the count of distinct values in that column. This just gives quick access to statistical…

                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 →
                • Change Table Icon for Trigger

                  Can we get an change in the table icon, or an indicator in intellisense (ideally both), that lets someone know there is a trigger on a table? Triggers are often hidden, and it would be nice to have them marked in SSMS, as well as noted when someone is altering or querying a table.

                  8 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 →
                  • MERGE - Highlighting

                    It would be nice to have consistent behavior between an INSERT statement and the INSERT within a MERGE statement. When I have an INSERT statement, when I move across the column names, the corresponding column/value in the VALUES clause is highlighted and vice versa. When I attempt to do the same thing for an INSERT within a MERGE statement, I get nothing. No highlighting at all. This makes it extremely tedious to figure out if you have a mismatch between the column list and VALUES clause of the INSERT. The only way I've found to do this is to rip…

                    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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                    • Comment

                      Can you do to allow comment the selected text and not the whole line?

                      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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                      • Prefered server Connection List

                        When working all day long with serveral SQL servers, its really annoying to click on "change connection" button + enter the server name you want to connect to, and enter credential.... It would be really great we we would have a "server connection list" where we could build into settings.... So i could add all my server i'm use to connect everyday, and specifying the USERNAME + PASSWORD + Default DB..... So in one-two click, i could switch to another server really quicly

                        10 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 →
                        • SQL Server data tools

                          Can all the SQL Prompt features be made available for SQL Server Data Tools in Visual Studio 2015?
                          Like Tab History, Tab colours etc.

                          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 →
                          • Support formatting sql even if it cannot be validated, as best as possible

                            Support formatting sql even if it cannot be validated, as best as possible. Sometimes we need to format the sql so that we can read it just so that we can see what is wrong. Other tools, such as Poor Man's TSQL formatter can do this.

                            8 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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add the command "USE [DatabaseName]" at the top of the script, when using the 'Script Object as Alter F12' feature.

                              Hi,
                              I really love the feature to just press F12 on SP and SQLPrompt opens a new query window with an alter script. It improves the productivity and it's a way easier then scrolling or filtering in the object explorer or using the tool tip by copy & paste the definition.

                              Do you know if there is any possibility to add the command "USE [DatabaseName]" at the top of the script. So, in case I need to switch my connection to a different server I don't need to select my database from the available database list drop down in SSMS.

                              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…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Show SELECT INTO within the Summarize Script pane

                                Within the Summarize Script pane, it would be helpful to differentiate between a SELECT statement (which returns output to the user) and a SELECT INTO statement (which creates a table and loads data into it).

                                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 →
                                • Visual Studio: Provide a copy of a ready to use SQL String in code

                                  Overall SQL prompt seems to me to be a good product and help me me to efficiently create complex SQL statements (joins etc.).

                                  I work a lot with visual studio and sometimes it would be nice if there were a function to get a copy of a prepared SQL String (created with SQL Prompt) to my source code

                                  C#: string sql = ...
                                  VB: dim sql as string = ...

                                  Today I copied the SQL string in my source code and reformat it with string builder methods. An awkward job.

                                  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 →
                                  • I neeed to choose the schema in database to show sugests. My db´s have a lot of CDC tables. I wiating more then 10 minutos to processing

                                    I neeed to choose the schema in database to show sugests. My db´s have a lot of CDC tables. I wauting more then 10 minutos to processing

                                    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 →
                                    • Translate datepart shorthand codes to their full names

                                      Following Aaron Bertrand's excellent post on date/time operations (http://sqlblog.com/blogs/aaron_bertrand/archive/2011/09/20/bad-habits-to-kick-using-shorthand-with-date-time-operations.aspx), I've gotten into the habit of using full names in things like the DATEADD operator.

                                      Thus, instead of

                                      SELECT DATEADD(d,1,GETDATE())

                                      I would use

                                      SELECT DATEADD(DAY,1,GETDATE())

                                      It would be great to see an option to translate datepart shorthand into the full names

                                      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 →
                                      • Fix "expand wildcards" when there is no space after the wildcard

                                        If there is no space between a wildcard (e.g., SELECT *) and the next statement, then when Format SQL expands the column list there will be no space between the last column and the next word, causing the script to error.

                                        I found this out the hard way when trying to format a gnarly set of code from our offshore team - an example to reproduce the issue is below.

                                        CREATE TABLE #MyTable (MyIntColumn INT, MyVarcharColumn VARCHAR(50))

                                        SELECT *INTO #MyOtherTable -- note the lack of a space between the * and INTO
                                        FROM #MyTable mt

                                        DROP TABLE #MyTable
                                        DROP TABLE…

                                        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  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Switch to a server from code

                                          I propose a feature where I can type a server and switch to it.

                                          Either by executing the line I just typed or that Prompt, after observing my keystrokes, does automatically

                                          Example,

                                          ===
                                          Select x ...

                                          --switch ServerX

                                          Select x ...
                                          ===

                                          If I execute the second line the connection would be to ServerX

                                          Note 1

                                          In SqlCmd mode we have the :CONNECT directive but its not permanent. SSMS switches to the new server and immediately switches to the old.
                                          Maybe this directive can be used if there is a way to not mess with the original semantics of putting…

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

                                          Feedback and Knowledge Base