269 results found

1. Remove Red Gate toolbar

   This is an old problem that just won't go away.

   The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.

   Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.

   Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).

   6 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   7 comments  ·  User interface  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   Hi all,

   Thanks for your help tracking this down! I’ve made a fix for the permission issue here:
   http://download.red-gate.com/EAP/SSMSIntegrationPackFramework/SSMSIntegrationPackFramework_1.0.31.0.exe
   Which should work without having to run as an administrator. We’ll look into getting this included in the SQL Search and Developer Bundle installers.

   Thanks,
   Aaron.

2. IF statement format options

   Please provide the option to format IF statements as follows, based on the format settings sample.

   IF @productType IN ('a', 'b', 'd', 'g', 'i', 'O', 'Q', 'X', 'Z') BEGIN

   ----IF @cost <= @compareprice BEGIN

   --------PRINT 'Less than $' + CAST(@compareprice AS varchar(20))

   ----END ELSE BEGIN

   --------PRINT 'Exceeds $' + CAST(@compareprice AS varchar(20))

   ----END

   END

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Thomas Walsh responded

   We’ve released a brand new formatting system in version 8 of SQL Prompt and have made further improvements since.

   You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

   If there is something missing please let us know by opening a new suggestion.

   Kind regards,

   The Prompt Team

3. Aggregate Functions wrongly put in square brackets

   I think I 've found a bug...
   If you Format this SQL

        DECLARE @Translations TABLE
           (
             [FundTypeId] INT NOT NULL ,
             [ColumnName] NVARCHAR(128) NULL ,
             [ColumnValue] NVARCHAR(256) NULL ,
             [InsertedAt] DATETIME NULL ,
             [InsertedBy] NVARCHAR(256) NULL ,
             [LastUpdatedAt] DATETIME NULL ,
             [LastUpdatedBy] NVARCHAR(256) NULL ,
             PRIMARY KEY ( [FundTypeId] )
           );
   
        SELECT *
        FROM   ( SELECT    [pt].[FundTypeId] ,
                           [pt].[FundType] ,
                           [pt].[Comment] ,
                           [pt].[InsertedAt] ,
                           [pt].[InsertedBy] ,
                           [pt].[LastUpdatedAt] ,
                           [pt].[LastUpdatedBy]
                 FROM      @Translations AS [tmp] PIVOT ( MAX([ColumnValue]) FOR [tmp].[ColumnName] IN ( [FundType], [Comment] ) ) AS [pt]
               ) AS [tmp];
   

   ... it will break the code as the MAX function of the PIVOT is put into square brackets...
   Regards
   Ralf

   I think I 've found a bug...
   If you Format this SQL

        DECLARE @Translations TABLE
           (
             [FundTypeId] INT NOT NULL ,
             [ColumnName] NVARCHAR(128) NULL ,
             [ColumnValue] NVARCHAR(256) NULL ,
             [InsertedAt] DATETIME NULL ,
             [InsertedBy] NVARCHAR(256) NULL ,
             [LastUpdatedAt] DATETIME NULL ,
             [LastUpdatedBy] NVARCHAR(256) NULL ,
             PRIMARY KEY ( [FundTypeId] )
           );
   
        SELECT *
        FROM   ( SELECT    [pt].[FundTypeId] ,
                           [pt].[FundType] ,
                           [pt].[Comment] ,
                           [pt].[InsertedAt] ,
                           [pt].[InsertedBy] ,
                           [pt].[LastUpdatedAt] ,
                           [pt].[LastUpdatedBy]
                 FROM      @Translations AS [tmp] PIVOT ( MAX([ColumnValue]) FOR [tmp].[ColumnName] IN ( [FundType], [Comment] ) ) AS [pt]
               ) AS [tmp];
   

   ... it will break the code as the MAX function of… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   We’ve just released a new build of Prompt ( 6.5.0.332) which should have a fix for this. You can get the latest version from our website http://www.red-gate.com/products/sql-development/sql-prompt/

4. Add a menu option to decrypt stored procedures

   It would be useful to add an option to decrypt encrypted stored procedures and display the decrypted SQL in a query tab.
   We often work with encrypted SP's on customer databases, but when there is a bug report, it is often hard to see what is going wrong.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   5 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   Hi Dirk,

   This is already available in the latest SQL Prompt. It’s on by default but just to double check it’s enabled for you, there’s a checkbox at the bottom of the behavior page in the options named “Decrypt encrypted objects”.

   Thanks,
   Aaron.

5. Add wildcards to tab coloring

   Would be useful if tab coloring supported wildcards
   eg *.sql = production
   *.dev = development etc

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Tab coloring  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   Hi Nigel,

   Wildcards are already supported for tab coloring in the latest version of Prompt. Just use a * for the wildcard in either the server or database column on the tab color options page. If you’re having any problems with this, please send me an email: aaron.law@red-gate.com

6. Inserting the AS keyword for aliases

   It would be nice if one could click a button and get the AS keyword between an object name and its alias. This would help with code that doesn't use AS to separate the two. And would also help readability.

   Thanks.

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   This feature was released in version 7.3 of SQL Prompt.

   If there are any missing features please let us know by creating a new suggestion.

   Kind Regards,
   The Prompt Team

7. Add Comment Block to Surround With choices

   Can you add a comment block /* */ to the Surround With choices? It would be of great use.

   I also like the idea of adding Surround With options to the snippet editor where one could specify the before and after.

   The example one person gave was Surround With ISNull( <highlighted column> ,0)

   9 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   SQL Prompt 7 includes a $SELECTEDTEXT$ snippet placeholder which allows you to create surround with snippets that can be used through the Actions List (it also has a comment feature that’ll add — to the start of every line). You can download the latest build from http://www.red-gate.com/products/sql-development/sql-prompt/

8. highlight all columns and filters for a table alias when that alias is selected

   when selecting a particular table alias, can you highlight all places where that alias is being used like in notepad++

   5 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   We’ve added the “Highlight matching objects” experimental feature in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

9. "d" in "order by" should prompt with "desc", not "dbcc"

   Currently if you type a query like this:

   select *
   from sys.objects o
   order by o.name d[CURSOR]

   the popup consists of dbcc, deallocate, declare, delete, deny, desc, disable trigger, drop, dump.

   While that is probably technically accurate, it would be much more helpful to make "desc" the first entry in the list, because it's what I'm typing 100% of the time.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Intellisense  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

10. Better SQLXML Support....

    SQL XML is a great tool that gets very little support. When I am on an XML type variable...the intellisense isn't great....AT ALL. Doing something like:

    declare @xml XML;
    set @xml = '<Tests><Test><Id>1</Id></Test></Tests>';

    select @xml.value --This doesn't have intellisense. It will try to capitalize .value to .VALUE which isn't correct.

    So better SQL XML support would be nice.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    Hi Mario,

    In your example “value” will be suggested and left as lowercase in the latest version of Prompt 6. If you’re still having problems even on the latest version please contact support as you may have hit a bug.

    Thanks,
    Aaron.

11. RECEIVE statement - Format SQL ignores

    ;
    RECEIVE TOP(1)
    @h = conversationhandle,
    @t = messagetypename,
    @b = messagebody
    FROM SimpleQueueTarget

    From the Service Broker Workbench on Simple Talk.

    It only moves the semicolon to a separate line. No errors. Ignores "comma at start".

    And, yes, the @'s above probably start in column 1, when they're actually in col 5.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 8 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

12. Auto complete/intellisense suggestions using PIVOT

    Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.

    The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)

    Ex:[code]CREATE TABLE dbo.tbTest(
    Id INT,
    foo VARCHAR(3),
    bar FLOAT
    )
    GO
    INSERT INTO dbo.tbTest
    VALUES (1, 'foo', 2)
    , (2, 'bar', 3)
    , (3, 'foo', 4)
    GO
    SELECT *
    FROM (
    SELECT *
    FROM dbo.tbTest AS tt
    ) pvt
    PIVOT (
    MAX(bar) FOR foo IN ([foo], [bar])
    )p
    [/code]
    Expanding the * gives the pvt alias, not the p alias. The same goes for the intellisense suggestions and automated prefix additions...

    Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.

    The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)

    Ex:[code]CREATE TABLE dbo.tbTest(
    Id INT,
    foo VARCHAR(3),
    bar FLOAT
    )
    GO
    INSERT INTO dbo.tbTest
    VALUES (1, 'foo', 2)
    , (2, 'bar', 3)
    , (3, 'foo', 4)
    GO
    SELECT *
    FROM (
    SELECT *
    FROM dbo.tbTest AS tt
    ) pvt
    PIVOT (
    MAX(bar) FOR foo IN ([foo], [bar])
    )p
    [/code]… more

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Qualify object names  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    This is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

13. Add support for SQL CMD variables in SSDT/VisualStudio

    When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.

    SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
    Then a becomes an "unresolved alias"

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

14. Tab Coloring

    Had this discussion with some folks at work today. SSMS Toolspack does tab coloring but it places a color band across the entire width of the query editor while SQL Prompt's tab coloring only colors the tab. The whole line is a much more obvious reminder. Be great if SQL Prompt did a similar thing. I realize Tab coloring is an experimental feature still.

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  Tab coloring  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    SQL Prompt 7 colors the status strip which covers the entire width of the editor. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/

15. Give Format SQL the ability to convert X.Field1 AS NewFieldName format to FieldName = X.Field1

    We have a lot of legacy code that is written as

    SELECT Field1 as Name1, Field2 Name2 FROM Table X
    (Sometimes they use AS when setting the alias, othertimes they do not).

    I would love the ability to convert this to
    SELECT
    Name1 = X.Field1
    , Name2 = X.Field2
    FROM Table X

    Both having the ability to switch between Name = Value and Value AS Name and to auto add the alias to all fields.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    6 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

16. Remove trailing spaces

    Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting

    7 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Thomas Walsh responded

    Version 8 of SQL Prompt allows you to do this as part of its new formatting system.

    You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

    If there is something missing please let us know by opening a new suggestion.

    Kind regards,

    The Prompt Team

17. Qualify Ojects in SQL (Add square brackets)

    When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:

    CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
    Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
    Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

18. Tab History (aka SQL Tab Magic) should not show currently open windows

    I love Tab Magic (or Tab History), but the with the latest version it also shows the tabs that are currently open. I would like an option to ignore currently open tabs. I can search those tabs right in SSMS, I need Tab History just for ones I've already closed.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    We’ve added a “closed tabs” option in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

19. Insert Statement Highlighting with Split-Screen

    Excellent work by the team in SQL Prompt 6.4 implementing the "Insert Statement Highlighting Column and Value" feature.

    http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/4223150-insert-statement-highlighting-column-and-value

    It would be great if this could be tweaked to work with split-screen editing. For example, if you have a REAAALLLY wide table, you might want to have your editing cursor in the bottom pane of SSMS but be looking at the top pane.

    To clarify, I am talking about allowing the highlighting to work in both the top and bottom panes if you enable Window... Split (or drag the thing down at the top of the scroll bar).

    This new feature is amazing though!!! Thanks!

    Excellent work by the team in SQL Prompt 6.4 implementing the "Insert Statement Highlighting Column and Value" feature.

    http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/4223150-insert-statement-highlighting-column-and-value

    It would be great if this could be tweaked to work with split-screen editing. For example, if you have a REAAALLLY wide table, you might want to have your editing cursor in the bottom pane of SSMS but be looking at the top pane.

    To clarify, I am talking about allowing the highlighting to work in both the top and bottom panes if you enable Window... Split (or drag the thing down at the top of the scroll bar).

    This new… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    We’ve just release 6.4.0.657 which should have the highlighting on both panes of the split window. You can get the latest build either from Check for Updates inside Prompt or from our website: http://www.red-gate.com/products/sql-development/sql-prompt/

20. Retrieve BETA Updates when checking for updates

    I usually run the latest version of the beta and it would be nice if "Check for Updates" would pick up the latest version version of SQL Prompt, including any beta versions.
    Perhaps this could be an option for those that aren't interested in participating in betas.

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    SQL Prompt 7 now has a button to toggle beta updates on the check for updates dialog.