Released: Jul 12, 2023

Aggiornamenti in V6.15.5

Funzionalità

• Added support for the GENERATE_SERIES and OPENQUERY relational operators.
• Added support for the following functions: LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, and SET_BIT.
• Added support for the APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC aggregate functions.
• Added support for the DATETRUNC function.
• Improved memory utilization during the processing of suggestions.
• Optimized the search functionality for the 'Go To Definition' feature.

Correzioni

• Fixed issues with SQL...

Released: Jun 15, 2023

Aggiornamenti in V6.14.26

Correzioni

• Fixed an issue causing the Completion List window size to reset to default.
• Fixed an issue with the debugger starting.
• Resolved an issue where the Continue, Step Over, and Step Into buttons were occasionally disabled when breaking execution.
• Fixed an issue with the restoration of the latest active document session when launching SSMS 18 after a previous SQL Complete update.

Released: May 12, 2023

Aggiornamenti in V6.14.18

Funzionalità

• Optimized RAM usage.

Correzioni

• Fixed an issue with the incomplete loading of the extension in SSMS.
• Fixed an error that could occur when integrating the application into SSMS 19.0.1.
• Fixed an error that could occur when displaying the completion list.
• Fixed a column hint for the table CTE.
• Fixed an issue with hints got missing in the completion list if the server and database had the same name.
• Fixed a logging file initialization error that occurred when launching the application...

Released: Dec 30, 2022

Aggiornamenti in V6.14.7

Funzionalità

• Added support for Microsoft SQL Server Management Studio (SSMS) 19 Preview 4.
• Added column suggestions in ORDER clause for CREATE CLUSTERED INDEX statement.
• Added filegroups suggestions after SELECT INTO ON statement.
• Improved memory handling.
• Improved performance of hint processing.
• Improved formatting of SQL statements.

Correzioni

• Fixed issues with Azure Active Directory - Universal with MFA authentication.
• Fixed errors that occurred when working with synonyms when searching for...

Released: Oct 5, 2022

Aggiornamenti in V6.12.8

Correzioni

• Fixed an error that occurred when determining the JOIN clause for the completion list.
• Fixed a bug that occurred when opening multiple SSMS instances.

Released: Sep 12, 2022

Aggiornamenti in V6.12.6

Funzionalità

• Microsoft SQL Server 2022 - Added support for:
  • 'ALTER DATABASE SCOPED CONFIGURATION'.
  • 'ALTER INDEX'.
  • 'ALTER TABLE'.
  • 'CREATE CLUSTERED INDEX'.
  • 'CREATE INDEX'.
  • 'CREATE TABLE'.
• Added query hints for 'DELETE', 'INSERT', 'SELECT', 'UPDATE' and 'MERGE' statements.
• Added support for 'BACKUP SYMMETRIC KEY' syntax construct.
• Added support for 'RESTORE SYMMETRIC KEY' syntax construct.
• Added support for 'DATE_BUCKET' function in Completion List, Quick Info and Parameter Information.

Correzioni...

Released: Jul 20, 2022

Aggiornamenti in V6.11.5

Correzioni

• Fixed an error that might occur when a computer entered sleep mode.
• Fixed an issue with switching the active window in VS to the Debug window and vice versa.

Released: Jun 24, 2022

Aggiornamenti in V6.11.3

Funzionalità

• Added support for Microsoft SQL Server Management Studio (SSMS) v19 Preview 2.

Correzioni

• Fixed an application error that occurred when starting SSMS 2014.
• Fixed the display of data in Data Viewer when changing the order of columns in the Editor.
• Fixed an error that might occur when opening documents.
• Fixed an issue with displaying Quick Info on an incomplete script.
• Fixed an issue with missing hints for Linked Server objects.
• Added temporary table hints that do not depend on the...

Released: Apr 4, 2022

Aggiornamenti in V6.10.5

Funzionalità

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

Correzioni

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

Released: Jan 31, 2022

Aggiornamenti in V6.9.34

Funzionalità

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

Correzioni

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