EMS SQL Query for SQL Server

EMS SQL Query for SQL Server 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.

Features: EMS SQL Query for SQL Server is an utility for building SQL queries. This is specifically for MS SQL databases. You can build these queries visually and can edit them in text too depending on what suits you at that moment. It is able to support Microsoft SQL Server 7, 2000 and 2005. The user interface is graphical and easy to use. You have drag & drop convenience when selecting tables and fields for a query. You could work with several queries on separate windows. The user-friendly graphical interface can let you connect databases. You can select tables and fields too. It is possible to set the selection criteria at this stage too. You can work with several queries at once. Editing of queries and viewing of the execution results is possible in several modes. Any other operations that you may need in database work also can e performed at this stage.

Multiple database connections can be made, you can register databases for working with required databases only. Another mode of query creation available is by navigating through recent queries and picking the queries you need. You would be able to create queries by unions and sub-queries also visually. Another alternative is to create diagrams from queries. Syntax highlights, "quick code" and keyboard templates are available for quick editing of queries. Asynchronous query operation is possible. It is possible to view and edit several types of BLOB data. Unicode is supported, the interface also supports multi-language capability.

Overall: A really handy tool for query creations. Helpful if you do a lot of database work with the MS databases.

EMS SQL Query for SQL Server 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 databases, 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
- 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