EMS SQL Query for SQL Server

EMS SQL Query for SQL Server is a useful tool that lets you quickly and simply build SQL queries to SQL Server databases. Visual SQL Server query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to SQL Server databases, select tables and fields for a query to SQL Server, set the selection criteria and much more. Using this query utility you can work with several SQL Server queries at once, edit query text in the powerful SQL editor, view the execution results in different modes, create SQL Server queries with unions and subqueries visually, build diagrams based on queries, view SQL Server query execution plans and perform any other operations you may need in your work with SQL Server database queries.

Key Features

* User-friendly graphical interface

* 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

* Tools 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