EMS SQL Query 2007 for SQL Server 3.0

EMS SQL Query 2007 for SQL Server 3.0 offers you an professional and powerful utility that can help 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.

Major Features:

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

• Support for UNICODE-data in the grid
• Asynchronous query execution
• Added HTML View and Hexadecimal View for BLOB fields
• Extended the functionality of ToolTips in DB Explorer
• Comments for fields are now displayed in SQL Assistant
• Added the SQL TimeOut option
• Other major improvements

Requirements:

• Pentium 300
• 32 MB RAM
• Possibility to connect to some local or remote DB2 server
• IBM DB2 client software installed