Released: Apr 25, 2019

Updates in 9.5.0

Funktionen

• Adds support for SQL Server Management Studio 18.
• Adds support for Visual Studio 2019.
• Now requires .Net Framework 4.7.2 or later.

Fehlerkorrekturen

• SP-7522 : Fixed an issue of incorrect wildcard expansion from a nested SELECT containing CASE.
• SP-7545 : Fixed an issue where aliases were not being suggested within nested scopes.

Released: Apr 8, 2019

Updates in 9.4.16

Funktionen

• Optimized start-up time when a large number of tabs are being restored.

Released: Mar 28, 2019

Updates in 9.4.15

Funktionen

• You can now filter the suggestions that SQL Prompt shows by schemas, in addition to servers and databases.

Fehlerkorrekturen

• Qualify Object Names no longer unqualifies parameters of rowset functions.
• EI028 no longer fires on IDENTITY columns.
• Format SQL no longer throws an error when trying to format TRIM statements that specify which characters to trim.

Released: Mar 20, 2019

Updates in 9.4.14

Funktionen

• Now supports the latest pre-release of SSMS 18.

Released: Mar 6, 2019

Updates in 9.4.12

Funktionen

• The Check for Updates popup now shows both the latest available version and your currently installed version.

Fehlerkorrekturen

• Fixed a bug where attempting to insert semicolons on scripts containing ALTER EVENT SESSION START/STOP statements would sometimes result in incorrect semicolon placement.
• Fixed a bug where attempting to autofix some scripts would throw an error.
• Fixed a bug where InsertSemicolons refactoring would insert semicolons after GO command followed by a WITH clause.

Released: Feb 14, 2019

Updates in 9.4.10

Funktionen

• Based on customer feedback, the SQL Prompt experimental features are not going to be deprecated yet.
• The suggestions pop-up can be made transparent by holding down the Ctrl key, allowing you to see what is behind it.
• The keyboard shortcut to open code analysis issues has been changed to Ctrl+Shift+E.

Fehlerkorrekturen

• BP014 no longer reports an issue with columns that don't declare NULL/NOT NULL if that column is a primary key.
• Qualify Object Names no longer tries to qualify column...

Released: Jan 9, 2019

Updates in 9.4.7

Funktionen

• Code analysis: You can now automatically fix code analysis issues directly from your editor window. Just click the yellow lightbulb and select the auto-fix option.
• The Code Analysis lightbulb is now much more responsive with its re-positioning when scrolling through your scripts.
• You can now bring up the List of Code Analysis Issues using the keyboard shortcut Ctrl+Shift+Y.

Fehlerkorrekturen

• SP-6956 : Fixed typo in built-in method (CONCAT_WS instead of CONCAT_WD) when running PE...

Released: Dec 13, 2018

Updates in 9.4.6

Funktionen

• You can automatically fix BP022 issues in your script (it replaces the usage of the MONEY or SMALLMONEY datatype with the Decimal(19, 4) datatype).
• "Check for Updates" renders as a popup in the bottom right rather than as a big modal.
  • User can dismiss the popup, setting it to remind them tomorrow, in a week or skip the version entirely.

Fehlerkorrekturen

• SP-6956 : PE017 correctly considers the following functions as built-in system ones:
  • CONCAT
  • CONCAT_WD
  • FORMAT
  • TRANSLATE
  • TRIM...

Released: Oct 17, 2018

Updates in 9.4

Funktionen

• You can now automatically fix ST006 code analysis issues in your script:
  • Issues that are fixable are represented by an orange lightbulb icon in the sidebar, rather than the traditional blue one.
  • Clicking on the lightbulb will show the issue details pane, which when applicable, will contain a button labeled "Apply Fix".
  • Clicking this button will automatically fix the relevant issue in the script.
• Added auto completion for the following query hints:
  • KEEP UNION
  • MAX_GRANT_PERCENT
  • MIN...

Released: Sep 26, 2018

Updates in 9.3

Funktionen

• You can now refactor INSERT statements into UPDATE statements, making it easier to update the data in your tables.
  • This can be triggered by either right clicking in the script window and selecting the command, or by using the keyboard shortcut Ctrl+B, Ctrl+P.
  • The refactoring automatically adds a default WHERE clause, which you can customize to suit your needs.
• You can now go directly to the Product Learning section of the Redgate Hub from within SQL Prompt.
  • Click SQL Prompt > Help...