Query Builder v3.5 release notes

Last modified: March 13, 2025

Compatibility

• SQL Server 2012 LocalDB support

Query Profiler

• Query bottlenecks will be easy to find with this tool, as it allows viewing query execution statistics. After you apply improvements, you can compare the current statistics with the previous results to consider if your changes were effective.

Generate Script As

• Generate template SQL SELECT, UPDATE, INSERT, DELETE scripts for tables from Database Explorer

Data export functionality to a CSV file

• Use column separator: tab, space, custom

Bug fixes

• Incorrect trial on Windows 8
• Incorrect behaviour with identity columns on adding data in Data Editor
• The navigation from the Error List to the specific error in a script
• Exclude computed columns from synchronization by default
• Error report when Estimated Rows exceeds the limits of integer in the Profiler document view
• Error on changing connection in SQL document
• Error on setting alias name in upper case
• Improvement of work with memory while redirecting data to the Output window
• Syntax error on executing the current statement using the Execute Current Statement command
• Syntax error on executing a script with @@ variables
• Issue with saving a file’s encoding
• Issue with the installation of the product
• Issue related to the focus, while executing several statements
• Issue with highlighting of the IIF function
• Issue in data editor with not assigning default values
• Issue with clearing memory on selecting data from table
• Issue with running the application on .NET Framework 4.5
• Issue with removing a record in Data Editor
• Issue with generating a schema name when exporting data using the MERGE mode
• Issue with applying a filter in Data Editor
• Issue with saving the Splitting options
• Issue with changing options for code editor
• Issue with connection to TFS 11
• Issue with displaying the ‘Code Completion’ options
• Issue with punctuation visibility in code editor with black background being set
• OutOfMemoryException on searching data in Data Editor
• ArgumentNullException on finding the next occurrence in text
• ArgumentException on opening a file using the command line
• SqlTypeException on executing a stored procedure with data entered out of the permissible range
• FileNotFoundException on opening the New File window
• NullReferenceException on editing data in Data Editor
• NullReferenceException while working with a query that contains PIVOT (in Query Builder)
• NullReferenceException on executing a query
• NullReferenceException on editing a table in the editor
• NullReferenceException on invoking Help in the Command Line
• NullReferenceException on adding rows in Data Editor
• NullReferenceException on retrieving data from the tables containing a BIGINT field
• NullReferenceException on trying to find a search pattern in a document
• NullReferenceException on executing a script
• NullReferenceException on opening the SMTP options page
• NullReferenceException on profiling a query
• NullReferenceException on searching a text in a SQL document
• NullReferenceException in Query Builder
• NullReferenceException on creating a SELECT query in Query Builder
• InvalidCastException on editing a subquery in Query Builder
• InvalidCastException on double-clicking a table in Database Explorer
• InvalidOperationException on executing a script
• InvalidOperationException while executing queries on SQL Azure
• InvalidOperationException on editing data in Data Editor
• InvalidOperationException on refreshing data in Database Explorer
• InvalidOperationException on closing a connection with invalid transaction
• InvalidOperationException on executing a query