Microsoft English Query is a development tool designed to give you the ability to create applications that allow users to query a Microsoft® SQL Server™ database in English. For example, users can ask, “How many widgets were sold in Washington last year?” instead of using the SQL statements:
SELECT sum(Orders.Quantity) from Orders, Parts
WHERE Orders.State='WA'
and Datepart(Orders.Purchase_Date,'Year')='1996'
and Parts.PartName='widget'
and Orders.Part_ID=Parts.Part_ID
When you install Microsoft English Query, a Start menu item named English Query is created in the Microsoft SQL Server 7.0 program group. It contains these shortcuts:
For more information, see English Query Help.
To install English Query