EMS SQL Query for SQL Server is an utility that lets you quickly and simply build SQL queries to Microsoft SQL databases

EMS SQL Query for SQL Server is an application that allows you to 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 databases, select tables and fields for a query, set the selection criteria and much 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.

Here are some key features of "EMS SQL Query for SQL Server":

· 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
· 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


Requirements:

· 300-megahertz (MHz) Pentium II-compatible or faster processor; 600--megahertz (MHz) or faster processor recommended
· 64 MB RAM or more; 128 MB or more recommended
· 20MB of available HD space for program installation
· Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution video adapter and monitor recommended
· Microsoft Mouse or compatible pointing device
· Microsoft Data Access Components (MDAC) or SQL Server Native Client
· Possibility to connect to any local or remote SQL Server


Limitations:

· 30-day trial