Released: Apr 4, 2022

V6.10.5 中的更新

功能

• Added support for new functions in Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID.
• Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function.

修補程式

• Fixed an unexpected exception that occurred when renaming a table in a project.
• Fixed an issue caused by SQL Complete catching a Data Pump exception.
• Fixed an issue that occurred when applying tab caption changes in new files.
• Fixed an issue...

Released: Jan 31, 2022

V6.9.34 中的更新

功能

• Optimized the retrieval of object information from the server and removed unnecessary sorting.

修補程式

• Fixed an issue that occurred when navigating to the document from the execution notification window.
• Fixed an issue that occurred when retrieving machine configuration details for an error report.
• Fixed an issue that occurred when formatting single-line queries.
• Fixed an issue that occurred when loading an assembly.
• Fixed an unexpected exception that occurred when working with the Document...

Released: Nov 15, 2021

V6.9.28 中的更新

修補程式

• Fixed an issue with opening a SQL document from a Microsoft Visual Studio project.
• Fixed an issue that occurred when working with SQL documents related to Visual Studio projects.
• Fixed an issue with loading the SQL Complete assembly after launching SSMS.
• Fixed an issue that occurred when working with variables in the SQLCMD mode.
• Fixed an issue that occurred when working with the CREATE SCHEMA statement in the SQL editor.
• Fixed an application launch issue.
• Fixed a document session...

Released: Oct 5, 2021

V6.9.16 中的更新

功能

• Added support for CONSTRAINT suggestions in ALTER TABLE statements.
• Added support for UPDATETEXT which can be used to update existing text, ntext, or image as a whole or just partially.
• Added support for DISTRIBUTED_AGG in SELECT - GROUP BY. The DISTRIBUTED_AGG hint can now be used in the SELECT - GROUP BY clause.
• Added support for ALTER/DROP DATABASE SCOPED CREDENTIAL.
• Added support for Configuration Options for Query Store in ALTER DATABASE.
• Added support for WAIT_AT_LOW_PRIORITY in ALTER...

Released: Aug 12, 2021

V6.8.20 中的更新

修補程式

• Fixed issue with opening a new document in SSMS.
• Fixed issue with writing execution history.
• Fixed issue with formatting GRANT EXEC.
• Fixed error with deleting the application because of the absence of access to the document folder of the current user.
• Fixed issue with non-working 'Add parentheses when inserting functions' option in Standard edition.

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...