dbForge SQL Complete 新版本發表

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