dbForge SQL Complete Standard full changelog

Fixed an issue where the editor lost selection after inserting a snippet (D164311, D165305)
Fixed an issue with database selection when opening a document by selecting the Script Object as CREATE/ALTER option (D127840)
Fixed an issue that occurred when describing server declarations (D164811)
Fixed an issue that occurred during quick text editing with tooltips displayed (D164461, D164486, D165122, D165669, D165644, D165738, D165742, D165242, D165886, D165761, D166965, D167215, D167082, D166869, D165977, D167773)
Fixed a connection retrieval issue in earlier versions of SSMS (D164434, D165441, D165973, D165985, D166187, D166080, D166181)
Improved the behavior of the CTRL K+X shortcut so that snippets now only open in comments (D165944)
Updated the format for DATE and TIME literals in Snippet Manager to comply with the ISO 8601 standard (D164767)
Added the Generate Script As BULK INSERT command to the Results window of Query Editor (D164594)
Fixed an issue that occurred after closing the document in Query Editor (D165158)
Improved the Copy Data As > HTML functionality by resolving issues with data extraction from SSMS results and adding HTML styles for the Copy Data As > HTML > To Clipboard format (D164141, D166268)
Fixed the "Index and length must refer to a location within the string" error (D164540)
Implemented handling for system errors that occur during file system operations (D164284)
Improved the display of object lists in text tooltips (D164659, D164686, D164700, D166219, D167566, D167865, D167927, D167930, D168422, D168653)
Fixed an issue that occurred when working with projects (D165200, D165588, D164891, D165715, D167304)

Improvements:
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
Support for Implicit Procedure Execution
User-reported bug fixes:
Resolved issues that arose when selecting the case for automatic formatting of identifiers (T252989, T257652, T269036, T270192, T276488, T270192, D76531, D125424, p162685, T307930, T309179, u33847234, p188493, D89127)
Resolved the issue where invoking FORMAT SELECTION caused the query to become invalid (D123102)
Fixed the issue where the Convert EXEC to SQL functionality failed to function on queries without named parameters (D135198)
Fixed the behavior of CTE aliases in subqueries (D135239)
Fixed the behavior of object hints in the FROM clause within table-valued functions (D143009)
Resolved the issue where formatting scripts containing regions caused the query to become invalid (D145046)
Added the capability to set the QUOTED_IDENTIFIER and ANSI_NULL

Code Completion improvements:
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
User-reported and internal bug fixes:
Improved memory utilization during the processing of suggestions (D107724)
Fixed issues with SQL document closing or losing focus (D109291, D109290)
Resolved an error that occurred when analyzing invalid objects (D119419)
Fixed an issue with generating CRUD operations for tables (D113761, D116787)
Resolved an issue where Completion List suggestions were not working properly after selecting a different Azure database in the SQL document connection field (D119532)
Optimized the search functionality for the Go To Definition feature (D119530)
Fixed handling of user literals when editing a snippet (D119126)

Optimized the RAM usage
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
Fixed an issue with the auto-formatting of input words