Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

SQL Server Companion Products

SQL Server 2000 includes companion products that are designed to integrate with Microsoft's goals of simplifying data access and providing an integrated data warehousing solution. The following are the companion products:

• Microsoft English Query

• Analysis Services

Microsoft English Query

Microsoft English Query is a tool that can translate English syntax into SQL statements (see Figure 2.13). For example, a user can enter the following question: “Who wrote The Gourmet Microwave?” Microsoft English Query automatically translates the English syntax into the following SQL statement:

select distinct dbo.authors.au_fname as "First Name", dbo.authors.au_lname as "Last Name"
 from dbo.titles, dbo.titleauthor, dbo.authors ...