Released: Sep 5, 2024

Aggiornamenti in V7.0.158

Funzionalità

• Introduced the Enterprise Edition of SQL Complete with T-SQL Code Analyzer.
• Added integration support for Microsoft Visual Studio 2022.
• Added integration support for Microsoft SQL Server Management Studio 20.2.
• Added support for non-aggregated columns in GROUP BY statements.
• Added support for viewing the MSDescription property for databases.
• Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements.
• Added support for the RSA_OAEP algorithm in CREATE COLUMN...

Released: Apr 12, 2024

Aggiornamenti in V6.16.4

Funzionalità

• Added integration support for Microsoft SQL Server Management Studio (SSMS) 20.x.

Released: Dec 28, 2023

Aggiornamenti in V6.15.20

Funzionalità

• Added support for the CREATE TABLE AS SELECT statement in Azure Synapse.
• Improved the performance of hint generation when working with scripts containing a large number of aliases.

Correzioni

• Fixed SSMS crash when generating quick info for typed objects like variables and functions.
• Fixed the unnecessary addition of parentheses when inserting a synonym for a table from the dropdown list.
• Fixed the Snippet Manager's behavior when changing the folder path for snippets.
• Fixed a leak of...

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.