Query Languages for Indexing Service

Indexing Service supports two types of query languages: the Indexing Service query language and the Structured Query Language (SQL) query language. An application or script that uses the appropriate application programming interface (API) can use either type of query language to submit the queries to Indexing Service. (The choice of API depends on several factors; see Programming APIs for a brief discussion.) The following table summarizes the correspondence between query languages and the APIs that support them.

Query LanguageSupporting APIs
Indexing Service Query LanguageISAPI Extensions,
OLE DB Helper,
Query Helper
SQL Query LanguageActiveX Data Objects,
OLE DB Provider

This section describes the Indexing Service query language and its dialects. It also describes the SQL language and its extensions. The topics include the following.

  • Indexing Service Query Language is a special language created for Indexing Service, first as Dialect 1 for Index Server 1.0, and now as Dialect 2, an extensible query language introduced with Indexing Service 3.0.
  • SQL Query Language is standard SQL with several extensions. It has been available for submitting queries from applications and scripts since Index Server 2.0.
  • Example Queries presents a few examples of queries that compare the two Indexing Service query language dialects and the SQL language.

For a reference to the syntaxes of Dialects 1 and 2 and the SQL language, see Query Language Syntax.

See Also

Secure Code Practices

 

Page view tracker