How Does English Query Work?

English Query harnesses a natural language processor to interpret sentences and process them into SQL queries that are sent to SQL Server for processing. If you had a table named Customers that contained a list of all your customers and their addresses, telephone numbers, ages, and email, you could issue the following requests for information:

Show me all the customers. 
How many customers are there?
Show customers with their address and phone and email.

English Query examines these queries and converts them into standard SQL queries:

select CustomerID from customers 
select count(distinct CustomerID) from customers
select CustomerID, address, phone, email from customers

Notice that in these examples, English Query ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial