276 results found

1. Bring back the Ctrl+B, Ctrl+B hotkey for removing square brackets please. I used it all the time and the last update seems to have removed

   I updated to SQL Prompt 9.4.7.7595 yesterday and since then I no longer have the hot key. It is still on the menu, but no hotkey. I used that feature hourly. If you wish, allow users to define the hotkey combinations or disable them, but simply removing them is inconvenient.

   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  ·  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  ·  AdminAdrian B (n/a, Redgate) responded

   This was a bug that has been fixed in SQL Prompt 9.4.8. Please upgrade to that version (or later) to restore the functionality.

   https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-4-release-notes#SQLPrompt9.4releasenotes-9.4.8.7733-16thJanuary2019

2. A Create/Declare Table statement with a Primary Key gives a false positive BP014 in Code Analysis

   If you have a table declared like this:
   Declare @Test table
   (TheKey int Primary Key,
   SomeData varchar(10) Not Null)

   I am told that for "TheKey" "[NOT] NULL option is not specified in CREATE/DECLARE TABLE statement" defined. But, a Primary Key can never be null, so it is NOT NULL by nature.

   So, when performing Code Analysis and the parser sees "Primary Key", "Not Null" should be inferred also.

   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  ·  Code Analysis  ·  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

   Hi,

   I’m pleased to announce this issue was fixed in version 9.4.10 of SQL Prompt. You can access the latest version from https://www.red-gate.com/products/sql-development/sql-prompt/

   Thank you for bringing it to our attention!

   Kind Regards,
   The Prompt Team

3. Duplicate Tab

   One of the common UI interaction features in browsers like Chrome and IE is Duplicate Tab feature.

   Ususally the reason you might want to do this, could be because you want to keep an UNALTERED TAB and do SOMETHING DIFFERENT with another page...

   In SSMS this could be a great feature. Example of use please (- I hear you ask)? You could be trying to change script and test the effect of that change vs the original!

   MUCH MUCH Further down the line, you could extend this feature, to highlight the differences between tabs, a bit similar to file compare / winmerge...

   This could also give sense of versioning of script to user....

   And guess what? While typing this I duplicate new Tab (in Chome) - to check that you haven't had a suggestion about versioning(!) - Wouldn't it be great to add this to SSMS?

   BTW, I love SQL Prompt :-)

   One of the common UI interaction features in browsers like Chrome and IE is Duplicate Tab feature.

   Ususally the reason you might want to do this, could be because you want to keep an UNALTERED TAB and do SOMETHING DIFFERENT with another page...

   In SSMS this could be a great feature. Example of use please (- I hear you ask)? You could be trying to change script and test the effect of that change vs the original!

   MUCH MUCH Further down the line, you could extend this feature, to highlight the differences between tabs, a bit similar to file compare… more

   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

   0 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  ·  AdminOwen Standage (Admin, Redgate) responded

   Hi,

   We’ve added this to SQL Prompt and it will be shipped in the next release.

   Thanks,

   Owen

4. Add support for Azure Active Directory authentication

   Referring to this forumpost: https://forums.red-gate.com/viewtopic.php?f=169&t=79794

   55 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

   8 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  ·  chiara.gardner@red-gate.com responded

   This is now completed and was shipped in v10.4

   Thank you for your input!

   Chiara

5. Command Line "Reformat All Files In Folder" and pre-Commit

   Opening over 2500 code objects to set a baseline format, required by a large customer, is a daunting manual task.

   Many of Red Gate's tools provide command-line functionality.

   Please add it to Prompt so we can bulk (re)format SPs, UDFs, Triggers. Integration into the commit-path (we use SVN) would be ideal for standardized check-ins (Commits).

   Can't recall whether a style is exportable... (License key awaited at new employer) Should be able to point to UNC location for the style to use.

   109 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

   28 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  ·  Adminjames.hemson (Admin, Redgate) responded

   Bulk operations for formatting and code analysis were added as part of SQL Prompt 10.7

   Bulk operations in SSMS - SQL Prompt 10

6. Add the option to replace NULL values for strings as empty strings when using 'Open in Excel'

   When using the new feature 'Open in Excel' (the results from the grid), it'd be handy to have an option to replace NULL string values with empty strings ''. Sure you could do ISNULL on all the columns that are a string data type, but it'd be handy to just have the option to have the 'Open in Excel' feature do it.

   The only way I've found to quickly do it is to export the data as a csv and use a powershell script with something like:
   Export-CSV -NoTypeInformation -Encoding "Unicode" -Delimiter "," $AttachmentPath
   (Get-Content $AttachmentPath) -replace "`0", "" | Set-Content $AttachmentPath

   Which is less than ideal. I was actually surprised Microsoft didn't put in the option themselves.

   When using the new feature 'Open in Excel' (the results from the grid), it'd be handy to have an option to replace NULL string values with empty strings ''. Sure you could do ISNULL on all the columns that are a string data type, but it'd be handy to just have the option to have the 'Open in Excel' feature do it.

   The only way I've found to quickly do it is to export the data as a csv and use a powershell script with something like:
   Export-CSV -NoTypeInformation -Encoding "Unicode" -Delimiter "," $AttachmentPath
   (Get-Content $AttachmentPath) -replace "`0", "" |… more

   8 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  ·  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.2 now exports NULL values as empty cells when using Open in Excel. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/

7. Warning on delete and update statements if no WHERE clause is specified

   It would be nice to get a warning on delete or update statements if you did not specify a where clause.

   23 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

   4 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

   SQL Prompt 7.2 displays execution warnings before executing DELETE or UPDATE statements without a WHERE clause. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/

8. Allow me to specify schemas to include or exclude

   The options to "Only load suggestions for certain databases" and "Don;t load suggestions for certain databases" are nice, but it'd be really useful to also be able to include or exclude on a per schema basis.

   34 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

   10 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  ·  AdminAlicja Leszczynska (Product Designer, Redgate) responded

   We added schema filtering in SQLPrompt 9.4.15. You can learn more about the feature here: https://documentation.red-gate.com/sp9/managing-sql-prompt-behavior/managing-connections-and-memory

   We would love to hear your feedback.

9. Let cursor jump to capitalized letters within words (CTRL+arrow)

   Hi there. Would it be possible to program a feature that is
   present in Visual Studio (I think ReSharper brings it
   into VS) which enables a programmer to select/move among
   parts of a word based on where the capital letters are? (CTRL+arrow)
   Say you have a variable called @ThisIsMyVariable.
   If you place the cursor at the end of the word and then
   press CTRL+<Left Arrow>, then it’d be nice if the cursor
   jumped to the beginnig of the next capital letter instead
   of the next word as is usual. This feature is very helpful in VS and I think it’d be very helpful in SSMS as well. Thanks.

   Hi there. Would it be possible to program a feature that is
   present in Visual Studio (I think ReSharper brings it
   into VS) which enables a programmer to select/move among
   parts of a word based on where the capital letters are? (CTRL+arrow)
   Say you have a variable called @ThisIsMyVariable.
   If you place the cursor at the end of the word and then
   press CTRL+<Left Arrow>, then it’d be nice if the cursor
   jumped to the beginnig of the next capital letter instead
   of the next word as is usual. This feature is very helpful in VS and I think it’d… more

   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

   1 comment  ·  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

   The latest version of Prompt has an experimental feature for “Change keyboard shortcut behavior for CamelCase words”

10. Set to off "Restore open tabs when SQL Server Managerment Studio starts"
    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

    completed  ·  1 comment  ·  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

11. Put single quote marks around highlighted text (including multiple lines)

    Very often i have copied a list of items i want to query in an IN() statement from the database, for example:

    abc
    def
    ghi
    jkl

    and I want to format it like this:

    'abc'
    'def'
    'ghi'
    'jkl'

    or better yet:

    'abc'
    

    , 'def'
    , 'ghi'
    , 'jkl'

    Being able to highlight, right click, and select an option do do this, would be incredibly helpful.

    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

    completed  ·  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

12. Formatting SQL Transaction

    It would be nice to have the code within a BEGIN TRAN and COMMIT be indented.

    BEGIN TRAN
    <ssss>INSERT....
    <ssss>UPDATE....
    COMMIT TRAN

    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

    4 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

    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

13. 2014 ctp2 support

    please add support for sql 2014 ctp2, i'm already using it and im sure others are as well and quite frankly i've grown very accustomed to using sql prompt that it became quite hard to work without it.

    i hope you can add the support really soon

    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

    completed  ·  5 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

14. Code Analysis config to flat file

    Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I know not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.

    Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway and cutting down on time spent on code review.

    Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I know not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.

    Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway… more

    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  ·  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  ·  AdminAlicja Leszczynska (Product Designer, Redgate) responded

    Hello,

    We added this feature recently (in SQL Prompt 9.1.0.4138).

    Now it is possible to save your settings file in a shared folder for the team to use or switch between different settings files. This is accessible via the Prompt menu : SQL Prompt > Manage Code Analysis Rules….

    Let me know if you find it helpful.

    Kind regards,
    Alicja

15. code analysis blocks object detail

    SQL Prompt v9.0.2.3223 use of Code Analysis has stopped the tooltip for showing structural details.

    ie: statement like SELECT a,b,c FROM dbo.TableRequiringLock WITH (ROWLOCK, XLOCK) WHERE ID = @key

    will just show TABLE HINT used when hovering over table name as opposed to showing the structure.

    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

    2 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  ·  FabiolaB responded

    Hi,

    I am pleased to inform you that your request has been taken into account. Please update to the latest version in order to use it!

    Regards,
    Fabiola

16. Add an analysis rule checking for semicolons as statement terminators.
    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

    completed  ·  1 comment  ·  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

17. Query Execution History

    Had this with SSMS Tools Pack but upon migrating to 2012 I ditched it in favor of SQL Prompt. The only thing I'm missing is a log of my Query History, time-stamped and searchable.

    106 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

    27 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  ·  Adminjames.hemson (Admin, Redgate) responded

    We've now released this feature in version 10.13

18. SQL Prompt > Format SQL Update for SQL Server 2016

    Any query where "AT TIME ZONE" is used (new feature in SS '16), the Format SQL throws and error.

    "SQL Prompt was unable to complete this operation. Problem areas have been highlighted"

    The highlighting start from "AT TIME ZONE..."

    Thank you

    14 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  ·  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  ·  Michael Clark responded

    We now support “AT TIME ZONE” in the latest release of SQL Prompt. You can download the latest release here:
    https://forum.red-gate.com/discussion/80988/latest-stable-build-of-sql-prompt-is-8-0-0-1241-11th-may#latest

    Thanks for your support!

19. SQL Formatter error

    When using OPENJSON with the WITH clause, the formatter does not recognize the WITH clause as valid SQL. This should format but throws an error:

    DECLARE @JSONString NVARCHAR(MAX) SET @JSONString = N'{"Vendors":[{"VendorNumber":200,"VendorName":"Vendor1"},{"VendorNumber":201,"Vendo2"},{"VendorNumber":202,"VendorName":"Vendor3"}]}'

    SELECT VendorNumber ,
    VendorName
    FROM OPENJSON(@JSONString, '$.Vendors')
    WITH (VendorNumber INT '$.VendorNumber', VendorName VARCHAR(50) '$.VendorName')

    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

    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  ·  Michael Clark responded

    This formatted error has been fixed in the latest version SQL Prompt 8:
    https://forum.red-gate.com/discussion/80988/latest-stable-build-of-sql-prompt-is-8-0-0-1241-11th-may#latest

    Thanks for your suggestion!

20. Enable support for SQL PROMPT in VS 2012

    Currently no love for VS 2012 - hurry, please!

    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

    10 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  ·  Paul Stephenson responded

    SQL Prompt 5.3.6 was released in October 2012 with support for Visual Studio 2012.