Released: May 23, 2019
9.5.5 での更新項目
Updates in SQL Prompt 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 SQL Prompt 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...
Released: May 14, 2019
v9.5.3 での更新項目
機能
-
New in SQL Prompt 9.5.3
- SQL Prompt 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.
-
New in SQL Doc 5.0
- The UI now runs as a 64 bit process.
*As of version 5.0.0, SQL Doc no...
Released: Apr 25, 2019
9.5.0 での更新項目
機能
New in SQL Prompt Pro v9.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.
不具合の修正
Fixes in SQL Prompt Pro v9.5.0
- 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 での更新項目
機能
Updates in SQL Prompt
- Optimized start-up time when a large number of tabs are being restored.
Released: Mar 28, 2019
9.4.15 での更新項目
機能
Updates in SQL Prompt
- You can now filter the suggestions that SQL Prompt shows by schemas, in addition to servers and databases.
不具合の修正
Fixes in SQL Prompt
- 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
9.4.14 での更新項目
機能
Updates in SQL Prompt
- Now supports the latest pre-release of SSMS 18.
Released: Mar 6, 2019
9.4.12 での更新項目
機能
Updates in SQL Prompt
- The Check for Updates popup now shows both the latest available version and your currently installed version.
不具合の修正
Fixes in SQL Prompt
- 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...
Released: Feb 14, 2019
9.4.10 での更新項目
機能
Updates in SQL Prompt
- 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.
不具合の修正
Fixes in SQL Prompt
- 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...
Released: Dec 13, 2018
9.4.6 での更新項目
機能
Updates in SQL Prompt
- 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.
不具合の修正
Fixes in SQL Prompt
- SP-6956 : PE017 correctly considers the following functions as built-in system ones:
- CONCAT
- CONCAT_WD
- FORMAT...
