Released: Jun 16, 2021

V6.8.13 中的更新

功能

• Added support for WITH INLINE for CREATE OR ALTER FUNCTION.
• Added support for APPROX_COUNT_DISTINCT.
• Added support for ALLOW_BATCH_MODE.

修補程式

• Incorrect behavior of the Go to Definition functionality when the table name matched any database name.
• A completion list disappeared when Visual Studio faced any issues within a script.
• SQL Complete used verbose tracing even when the option was disabled.
• Some schema objects were missing in the completion list due to specific circumstances.
• Possible...

Released: Mar 11, 2021

V6.7.13 中的更新

修補程式

• Copy HTML to clipboard did not format the clipboard as HTML.
• Possible add-in failure when displaying loads of query execution result.
• The objects just created within an SQL document were missing from completion list after opening a new query window.

Released: Feb 3, 2021

V6.7.5 中的更新

功能

• Now suggests COLUMN MASTER KEY.
• Now suggests COLUMN MASTER KEY in CREATE COLUMN ENCRYPTION KEY.
• Now suggests ALGORITHM in CREATE COLUMN ENCRYPTION KEY.
• Added support for the "Go To Definition" feature for COLUMN MASTER KEY.
• Added support for the "Script Object as CREATE/ALTER" feature for COLUMN MASTER KEY.
• Now suggests PERSISTENT_LOG_BUFFER=ON ( DIRECTORY_NAME='' ) in CREATE DATABASE.
• Now suggests DBCC SHOW_STATISTICS.
• CRUD generation is now wrapped to the regions.

修補程式

• When describing...

Released: Sep 16, 2020

V6.6.12 中的更新

修補程式

• Fixed an issue where SSMS was hanging when navigating through scripts with lots of temporary tables.
• Fixed an issue where columns that had multiple description properties specified were duplicated within the completion list.
• Fixed an issue where SSMS was hanging when trying to rename an alias.
• Fixed an issue with incorrect quotations when exporting data to CSV format.
• Fixed an issue where the 'OBJECT_ID' was present in the completion list twice.
• Fixed an issue where a CSV file with exported...

Released: Sep 1, 2020

V6.6.7 中的更新

功能

• Added column sensitivity classification information into the completion list and quick info. The statements to add and drop such classifications are also suggested in the completion list.
• Added export settings for CSV file format.
• Added an option to tune the accuracy of decimals for Grid Aggregates.
• Added the ability to export Execution History to CSV file format.
• Added the ability to convert stored routines into a script for procedures with incomplete parameters or with no parameters...

Released: Aug 18, 2020

V6.5.48 中的更新

修補程式

• Issue with restoring connection for cached documents in add-in due to the error when running SSMS 18.6.
• Missing hard brackets on object schema name when generating ALTER scripts for procedures and functions under the caret.
• Issue with code completion for SELECT queries without alias in the Express edition of the add-in.
• Absence of a table declared in an SQL file in completion list in case if the document is not currently connected to a server.
• Critical failure of the add-in when trying to...

Released: Aug 3, 2020

V6.5.38 中的更新

修補程式

• Issue restoring connection for cached documents in add-in due to error when running SSMS 18.6.
• Missing hard brackets on object schema name when generating ALTER scripts for procedures and functions under the caret.
• Improper work of code completion for SELECT queries without alias in the Express edition of the add-in.
• Absence of a table declared in SQL file in completion list if the document is not connected to a server.
• Critical failure of the add-in when trying to format SQL files larger...

Released: Jul 9, 2020

V6.5.27 中的更新

修補程式

• Fixed user-reported bugs.

Released: Jun 9, 2020

V6.5.23 中的更新

功能

• Added full support for Microsoft SQL Server 2019.
• Added SQL Complete Standard Edition.
• Added properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc.).
• Added temporary table suggestions.
• Added OPENJSON object suggestions.
• Added support for the following functions: NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT and PWDCOMPARE
• Added support for the following SQL statements: GRANT ALTER ANY SECURITY POLICY, GRANT ALTER ANY SENSITIVITY...

Released: Mar 17, 2020

6.4.28 中的更新

修補程式

• Fixed formatting problem.
• Fixed installation problem.
• Fixed problem with splitter in a SQL document.
• Fixed reactivation problem.
• Fixed other user reported bugs.