Softpedia >Windows >Internet >Servers >Database Utils >SQL Query for SQL Server >  Changelog

SQL Query for SQL Server Changelog

What's new in SQL Query for SQL Server 3.4.1.53700

Mar 31, 2020
  • Implemented support for Azure, SQL Server 2017, MySQL Server 8, PostgreSQL 12 and Firebird 3.0.
  • PostgreSQL. Added support for materialized views.
  • Oracle. Results for NCHAR columns are now displayed correctly.
  • Connection via SSH tunnel now supports passphrase.
  • The error occured on simultaneous registering of several databases. Fixed now.
  • The error was duplicated on switching between editor tabs. Fixed now.
  • PostgreSQL. WITH queries are now processed correctly.
  • Oracle. Connection with TNS_ADMIN environment variable is now supported.
  • Other fixes and improvements.

New in SQL Query for SQL Server 3.4.0.2 (Dec 10, 2014)

  • Now the Help file is opened in the selected language of the program.
  • SQL Query for MySQL:
  • - Added the possibility to check the “libmysql” library version.
  • - Query results of the Blob fields in UTF-8 were displayed incorrectly. Fixed now.
  • - SSH connection settings were not saved. Fixed now.
  • SQL Query for SQL Server:
  • - The queries retrieving data from the tables with the “hierarchyid” fields were executed incorrectly. Fixed now.
  • - The queries containing a condition with the Unicode text in the WHERE statements did not return a result. Fixed now.
  • - The join table condition, which used statements with constants, was decreased. Fixed now.
  • SQL Query for InterBase / Firebird. After executing the SELECT query, a dataset could not be switched to the "Load all rows" mode. Fixed now.
  • SQL Query for PostgreSQL. When joining tables, a query with the USING statement was not executed. Fixed now.
  • The sequence of such actions as: the execution of the correct query, which cannot be parsed; the transition to the “Builder” tab; the transition to the SQL Editor tab - caused the query text removal. Fixed now.
  • Some other improvements and bugfixes.

New in SQL Query for SQL Server 3.3.0.1 (Dec 1, 2011)

  • Added the possibility to parse subqueries in the JOIN statement.
  • Query Builder:
  • Added the automatic display of the JOIN statement for tables with foreign keys (DB2, InterBase/Firebird, MySQL, Oracle).
  • Added the possibility to use aggregate functions in the CASE statement.
  • Added the possibility to execute only the selected part of a query in Query Editor.
  • When parsing a query, which contained the name of a table starting with an underscore, AV error occurred. Fixed now.
  • In SQL Query for DB2 it was not possible to execute a query after error occurrence. Fixed now.
  • SQL Query for PostgreSQL:
  • It was not possible to execute query when using a cast operator. Fixed now.
  • When setting a button bar, the button headers were missing. Fixed now.
  • SQL Query for MySQL. When parsing the UPDATE query with a subquery in the WHERE clause, an error occurred. Fixed now.
  • SQL Query for InterBase/Firebird:
  • Executing queries with subqueries in the field list caused an error. Fixed now.
  • Now all data is sorted correctly.
  • The program parameters were saved incorrectly. Fixed now.
  • Some other improvements and bugfixes.

New in SQL Query for SQL Server 3.2 (Dec 1, 2011)

  • Unicode data support is implemented (InterBase/Firebird, DB2)
  • The Favourites tab is added to ensure fast access to Favorite Queries
  • The Optimize Goal option is added (Oracle)
  • The utility now requests re-connection when the connection to a database is lost (InterBase)
  • Added the “Show default schema” option which allows you to avoid specifying objects names when it is not necessary (SQL Server, Oracle, PostgreSQL, DB2)
  • Visual building of the FROM statement subqueries is now possible
  • User-defined aggregate functions are now available in the Aggregate drop-down list in Query Builder (PostgreSQL, SQL Server)
  • Some other small bugfixes and improvements

New in SQL Query for SQL Server 3.1 (Dec 1, 2011)

  • Queries are executed in a separate thread now (SQL Query for PostgreSQL, InterBase/Firebird)
  • Unicode support is implemented in SQL Editor
  • Faster connection to databases (SQL Query for SQL Server, DB2 and Oracle)
  • The ability to save program settings to a REG file is implemented
  • Windows authentication is added (SQL Query for Oracle)
  • Now fields listed at WHERE condition are deleted automatically upon deleting a table on the Builder tab
  • The "Operation is not allowed when object is closed" error is fixed now (SQL Query for SQL Server)
  • Some other small fixes and improvements

New in SQL Query for SQL Server 2.0 (Dec 1, 2011)

  • Query result output to a separate tab is now available.
  • Loading data to the grid for the queries returning a great number of strings in 'Load All Rows' mode now works much faster.
  • Handling errors with the connection to database extended.
  • Plotting graphical diagram based on the queries returning a great number of strings now can be cancelled.
  • Query Builder: 'Script Format' option works fine now.
  • SQL Editor: Quick Code - Code Case option worked incorrectly. Fixed now.
  • MS SQL Server: Improved support of non-standard table names implemented.
  • MySQL: The bug that appeared after multiple pressing the Explain Query button is fixed now.
  • InterBase/Firebird: Ability to connect through SSH tunnel implemented.
  • InterBase/Firebird: Now it is possible to choose client library.
  • Other small bug fixes and improvements.