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.