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 ENCRYPTION KEY statements.
• Added support for the COLUMN MASTER KEY server object.
• Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID.
• Added support for the TERTIARY_WEIGHTS function.
• Extended support for the AVAILABILITY GROUP constructs.
• Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button.
• Added the ability to save user-defined column layouts in Query History.
• Added CLI automation for Find Invalid Objects.
• Added Save Command Line for Find Invalid Objects.
• Added Save Command Line for SQL Formatter Wizard.
• Added support for Implicit Procedure Execution.
• Added the capability to set the QUOTED_IDENTIFIER and ANSI_NULLS options in queries generated by the Generate Script As functionality.
• Improved the behavior of displaying results in the data grid.
• Added a form to the Send Trace Log to Devart action for providing additional information.
• Improved the behavior of script generation for tables containing IDENTITY columns when using the Script Table As CRUD functionality.
• Improved the export of money data types to CSV format for the Copy Data As functionality.

Correzioni

• Resolved issues that arose when selecting the case for automatic formatting of identifiers.
• Resolved the issue where invoking FORMAT SELECTION caused the query to become invalid.
• Fixed the issue where the Convert EXEC to SQL functionality failed to function on queries without named parameters.
• Fixed the behavior of CTE aliases in subqueries.
• Fixed the behavior of object hints in the FROM clause within table-valued functions.
• Resolved the issue where formatting scripts containing regions caused the query to become invalid.
• Fixed an issue that occurred when using the Encrypt and TrustServerCertificate parameters in the connection string in SSMS 20.
• Fixed an issue where refreshing snippets did not reflect the most recent changes.
• Resolved the conflict of options that occurred when generating alias names: priority is now given to the mask.
• Fixed the configuration loading error.
• Resolved the integration bug that caused SSMS to crash.
• Addressed the issue causing Visual Studio to freeze when SQL Complete is installed.
• Resolved an issue with formatting XML expressions.
• Corrected the misspelling of JOIN's to JOINs in the formatting profile settings.
• Optimized the retrieval of foreign key declarations, resolving the freeze issue in SQL Complete.
• Fixed an issue with the formatting of identifiers when Text Case -> Identifier Case -> As in the database is selected.
• Fixed an issue that occurred when formatting scripts containing the IS DISTINCT FROM predicate.
• Optimized parsing and reference resolution to fix the freezing and crashing issue in SSMS.
• Resolved the issue where temporary tables were not shown in the suggestions.