SQL Prompt Pro のリリース
Released: Jun 26, 2019
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
9.5.7 での更新項目
機能
- 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
9.5.6 での更新項目
機能
- 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).
不具合の修正
- SP-7618 : SQL Prompt now suggests server roles in the relevant scenarios.
Released: May 23, 2019
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
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
v9.5.3 での更新項目
機能
- 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.
不具合の修正
- SP-7558 : Find Invalid Objects now reports triggers that are on non-existent tables.
Released: May 3, 2019
9.5.2 での更新項目
機能
- Added a `Show all issues` link to the autofix popup window.
不具合の修正
- 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.
Released: Apr 25, 2019
9.5.0 での更新項目
機能
- Adds support for SQL Server Management Studio 18.
- Adds support for Visual Studio 2019.
- Now requires .Net Framework 4.7.2 or later.
不具合の修正
- 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
9.4.16 での更新項目
機能
- Optimized start-up time when a large number of tabs are being restored.
Released: Mar 28, 2019
9.4.15 での更新項目
機能
- You can now filter the suggestions that SQL Prompt shows by schemas, in addition to servers and databases.
不具合の修正
- 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.
