English Query is a simple and handy development tool that works with Microsoft SQL Server 2000.
Using English Query, you can create applications that allow users to query a SQL Server database or an Analysis Services 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')='1999'
AND Parts.PartName='widget'
AND Orders.Part_ID=Parts.Part_ID
When you install English Query, EnglishQuery is added to the Microsoft SQL Server program group on the Start menu. English Query contains these shortcuts:
- English Query Books Online
- English Query Tutorials
- Microsoft English Query
If English Query is not installed with Microsoft SQL Server 2000, the Help system will access English Query Books Online, Eqdoc.chm, instead of SQL Server Books Online, SQL80.col. However, both documentation files contain essentially the same material about English Query and both provide context-sensitive (F1) Help for English Query. Regardless of the installation scenario, English Query Books Online is available from the English Query program group.
Installation Requirements for English Query are:
- Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows NT version 4.0 or later
- 40 MB of free disk space
- Microsoft Internet Explorer 5.0 or later
Simple utility that enables you to create applications that allow users to query a SQL Server database or an Analysis Services database in English.
Comments