SQL Prompt Pro Releases
Released: Jul 18, 2019
Updates in 9.5.11
Updates in 9.5.11
- Fixed an issue with incorrect handling of case sensitivity in Inline EXEC refactoring.
- SP-7713 : SQL Prompt execution warnings no longer trim the beginning of object names in some scenarios.
- SP-7715 : Fixed incorrect renaming of named parameters in Inline EXEC refactoring.
- SP-7719 : Fixed an issue with code analysis rule BP014 and how it deals with persisted computed columns.
- SP-7298 : Fixed an issue with built-in snippets triggering code analysis warnings.
Released: Jul 11, 2019
Updates in 9.5.10
Updates in 9.5.10
- SP-7718 : Restores the results grid actions (Script as INSERT, Copy as IN clause and Open in Excel) that were accidentally removed by the previous update.
- SP-7720 : Fixed a crash on startup of SQL Prompt affecting some installations.
Released: Jul 10, 2019
Updates in 9.5.9
Updates in 9.5.9
- In-product notifications that are dismissed will now not re-show until SQL Prompt is restarted.
Released: Jun 26, 2019
Updates in 9.5.8
Updates in 9.5.8
- SP-7656 : Fixed a bug where necessary whitespace would sometimes be omitted within the migration script when using Smart Rename.
- SP-7679 : Fixed a bug which would sometimes cause formatting to fail when extra semi-colons were present in scripts.
Released: Jun 17, 2019
Updates in 9.5.7
Funktionen
- The CamelCase navigation shortcut option has been moved out of the experimental features section to a new "Navigation" section.
- Added a "Welcome Window" to SQL Prompt that keeps you informed about new features in SQL Prompt and provides you with plenty of useful links.
Released: Jun 6, 2019
Updates in 9.5.6
Funktionen
- Added an execution warning for DROP statements, which can be found in the options menu under Suggestions > Warnings & highlighting > Execution Warnings. This option is off by default.
- You can now access the latest release notes for SQL Prompt from the help sub-menu (SQL Prompt > Help > Release Notes).
Fehlerkorrekturen
- SP-7618 : SQL Prompt now suggests server roles in the relevant scenarios.
Released: May 23, 2019
Updates in 9.5.5
Updates in 9.5.5
- SP-7626 : Fixed crash complaining about missing DLL that could occur when running Summarize Script, Encapsulate as a New Stored Procedure, Split Table, Smart Rename or Find Unused Variables and Parameters.
Released: May 22, 2019
Updates in 9.5.4
Updates in 9.5.4
- SP-6941 : Fixed an issue where formatting places ORDER BY clause on the next line when it is within WITHIN GROUP
- SP-7232 : Add suggestion support for some missing system functions: CONNECTIONPROPERTY, CURRENT_REQUEST_ID, CURRENT_TRANSACTION_ID and ORIGINAL_DB_NAME.
- SP-7583 : Fixed an issue where formatting ALTER INDEX within an ALTER TABLE statement would throw an error.
- SP-7596 : SQL Prompt now supports `TEMPORAL_HISTORY_RETENTION` and `HISTORY_RETENTION_PERIOD` keywords when...
Released: May 14, 2019
Updates in v9.5.3
Funktionen
- Now promotes recently used suggestions to the top of the suggestions box. This feature is enabled by default and persists only for the current session. It can be disabled on the Suggestions > Behavior page, under Show code suggestions.
- Added the ability to download the installer instead of running it when SQL Prompt informs that there is a new version available.
Fehlerkorrekturen
- SP-7558 : Find Invalid Objects now reports triggers that are on non-existent tables.
Released: May 3, 2019
Updates in 9.5.2
Funktionen
- Added a `Show all issues` link to the autofix popup window.
Fehlerkorrekturen
- Fixed an issue which was preventing SQL Prompt from launching when upgrading from a previous version.
- Fixed an issue which would sometimes cause unwanted newlines to be inserted into scripts generated from `Script Object as ALTER`.
- Fixed an issue which caused the `Smart Rename`, `Encapsulate Object as Stored Procedure` and `Split Table` features to not work for some users.
