EMS SQL Query for SQL Server 3.2

EMS SQL Query for SQL Server by EMS Database Management Solutions, Inc is an utility that lets you quickly and simply build SQL queries to Microsoft SQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to database, select tables and fields for a query, set the selection criteria and many more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.

Key Features:
- User-friendly graphical interface
- Support for Microsoft® SQL Server™ 7, 2000 and 2005
- Using drag-and-drop operations when selecting tables and fields for a query visually
- Working simultaneously with several queries in separate windows
- Registering databases for working with the required databases only
- Multiple database connections
- Navigation within recently used queries and selecting the required queries
- Syntax highlight, " quick code" and keyboard templates for faster editing query text
- Tool for data grouping and filtering
- The ability to create queries with unions and subqueries visually
- The ability to create diagrams based on queries
- Capabilities for viewing query plans
- Support of UNICODE data
- Asynchronous query execution
- Powerful BLOB viewer/editor with several types of viewing BLOB data
- Flexible personalization of graphical user interface
- Multi-language GUI support

EMS SQL Query for SQL Server 3.2 released

We are pleased to announce the new version of EMS SQL Query - the powerful utility that lets you quickly and simply build SQL queries to databases.

You can download version 3. 2 of EMS SQL Query for SQL Server [emssqlqueryforsqlserver3.2.exe] from the following link:
What' s new in SQL Query 3. 2?

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 build 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.

We hope you' ll enjoy working with our products.