dbForge SQL Complete 新版本發表

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.