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?

(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 option to exclude columns with default values when generating insert scripts

    For auto-generated Insert scripts, provide an option to exclude columns with a Default Value set, possibly drilled-down by data type.

    E.g. if a, say, DateTimeCreated column has a default value of GETDATE(), or CreatedByUser one has a default value of suser_name(), include or omit such columns when generating the insert scripts based on the stated preferences.

    1 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)

      We’ll send you updates on this idea

      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Format SQL Styles should allow EXEC parameters to be not wrapped/wrapped if longer than Wrap column

      For an EXEC I would like to be able to choose not to place parameters on a new line if shorter than the wrap column. I cannot see how to do this for an EXEC statement.

      I have logging functions that I do not want exploded into multiple lines because they take far too much space

      e.g.

      EXEC audit.usp_Log 'Validation', @ValidationProcedureName, @Title = '@ValidationProcedureName', @Value = @DataSetID;

      1 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)

        We’ll send you updates on this idea

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

        Add a Describe as Table context menu option to any selected query or result sets

        This would take the query, push it through sys.sp_describe_first_result_set, and create a Table variable for it

        This would make capturing interim results in complex queries much less tedious

        1 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)

          We’ll send you updates on this idea

          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Reconnect based on server

          When SSMS start and had tabs opened, it tries to reconnect to each tab and the startup is extremely slow especially if a server is not available (it happens very often when working with VPN's customers, for instance).
          What about a servers list to which to reconnect, instead of an on/off feature? We could enable for local and disable for external servers, for instance

          1 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)

            We’ll send you updates on this idea

            0 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
          • Import "Tab History" feature of SQL Prompt in Visual Studio, just like it is in SSMS.

            Import "Tab History" feature of SQL Prompt in Visual Studio, just like it is in SSMS. That feature is beautiful just the way it is in SSMS, would be nice to have it in Visual Studio as well.

            1 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)

              We’ll send you updates on this idea

              0 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
            • When style folder unavailable, don't default to the folder on C:\

              In order to share format styles across our team, we have a shared folder that holds our standard styles. Only problem is, after a reboot that folder doesn't always reconnect automatically. SQLPrompt then defaults to the local C:\ folder, which might have the outdated version of the styles. I'd rather it throw an error or alert me in some way that my default styles are not available.

              1 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)

                We’ll send you updates on this idea

                0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
              • Extended Event Viewer

                HI Redgate Team,

                it would be amazing to get the option to view an extended event target within SSMS in a grid.

                Something like this.

                http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/12/an-xevent-a-day-12-of-31-using-the-extended-events-ssms-addin.aspx

                Thanks for looking into this!

                Torsten
                Friend of Redgate

                1 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)

                  We’ll send you updates on this idea

                  0 comments  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Admin →
                • Grid Mode with the same Description (Extended Property) as tooltips like the Column

                  It would be useful to display the original columns Description (Extended Property) when you hover over the Results column header, just like you do it with the Columns of a Table

                  1 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)

                    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
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                    • Joining tables from other database tables does not include database name prefix with suggested join tables

                      I created a query that joins tables from another database (dbname..tablename) and had to join another table from that database.
                      The table I wanted to use came up as a suggestion because of the relation between those two tables. So I selected the table, but the databasename prefix wasn't added. That was a bit unfortunate

                      1 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)

                        We’ll send you updates on this idea

                        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                      • Align comparison operators for BETWEEN, LIKE, NOT LIKE

                        Just as it is possible to align comparison operators for =, <>, <, >, etc. would it then be possible to add BETWEEN, LIKE, NOT LIKE as well?

                        1 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)

                          We’ll send you updates on this idea

                          0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                        • disable the column picker for IN clauses

                          Give us the ability to disable the column picker for an IN clause, so that when you're trying to say "IN (3,4,5)", it doesn't keep popping up suggestions for a field.

                          1 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)

                            We’ll send you updates on this idea

                            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                          • Allow colours to be re-ordered in the Tabs > Colour dialog

                            Sometimes I need to change the priority of the colours, and that's really hard to do. Can you make it possible for us to reorder them?

                            1 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)

                              We’ll send you updates on this idea

                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • 1 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)

                                We’ll send you updates on this idea

                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • If the database settings password is empty, then the smart prompt does not come

                                If the database settings password is empty, then the smart prompt does not come

                                1 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)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add the function IIF and a len without formatting

                                  the function IIF could have an option with no formatting if the length of the string was set before.

                                  1 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)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Keep statement terminator ";" at the end of single line statements

                                    Add option to "Global - Whitespace - Semicolons" to keep the ";" at the end of single line statement when "Whitespace before Semicolon" is set to "New Line Before"

                                    ex:

                                    print 'blah';

                                    declare
                                    x integer
                                    ,y integer
                                    ;

                                    1 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)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Enable customization For 'FOR XML PATH' on a different line

                                      Enable customization For 'FOR XML PATH'' on a different line.

                                      This is how it looks in V7 formatting style:

                                      SELECT PaymentIDs = STUFF(( SELECT DISTINCT
                                      ',' + iap.PaymentId
                                      FROM TestDB2..TestTable2 AS iap
                                      WHERE iap.LoadId = CONVERT(VARCHAR(50), trx.LoadId)
                                      FOR
                                      XML PATH('')
                                      ), 1, 1, '')
                                      ,CardholderName = CASE WHEN cdt.CHType = 1 THEN ISNULL(cdt.FirstName, '') + ' ' + ISNULL(cdt.Lastname, '')
                                      ELSE cad.CompanyAccountName
                                      END
                                      FROM TestDB1..TestTable1 AS trx;

                                      This is how it looks in V8:

                                      SELECT TestColumn = STUFF(( SELECT DISTINCT
                                      ',' + iap.PaymentId
                                      FROM TestDB2..TestTable2 AS iap
                                      WHERE iap.LoadId = CONVERT(VARCHAR(50), trx.LoadId)
                                      FOR XML PATH(''))
                                      ,1
                                      ,1
                                      ,'')
                                      FROM TestDB1..TestTable1…

                                      4 votes
                                      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)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Include column picker for where clause and allow entering of variables/values

                                        When you type the WHERE clause, allow the user to choose from the column picker with textboxes on the right to allow the user to input the values.

                                        e.g.
                                        [ ] ID Value [_____________]
                                        [ ] Name Value [_____________]
                                        [ ] Surname Value [_____________]
                                        [ ] ID Number Value [_____________]
                                        [ ] Cellphone Number Value [_____________]

                                        0 votes
                                        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)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Instead of "Press Tab to expand wildcard", prompt for alternative tables or aliases to expand

                                          Instead of "Press Tab to expand wildcard", prompt for alternative tables or aliases to expand

                                          Example:

                                          select *
                                          from table t1
                                          join table2 t2 on t1.id = t2.id

                                          When cursor is on the wildcard the following options will be shown:

                                          Expand Wildcard
                                          * (Default Selected)
                                          t1.*
                                          t2.*

                                          2 votes
                                          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)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 32 33
                                          • Don't see your idea?

                                          Feedback and Knowledge Base