SQL Queries and SQL Extensions
Note Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.
Indexing Service accepts queries composed in structured query language (SQL). Indexing Service uses a SQL syntax which contains extensions to the subset of SQL-92 and SQL3 queries for relational database systems.
Visual Basic and Visual J++ applications and VBScript and JScript scripts can submit SQL queries using the methods of Microsoft ActiveX Data Objects (ADOs). Visual C++ applications can submit SQL queries using the interfaces of OLE DB Provider for Indexing Service.
This section describes the syntax of SQL queries for Indexing Service. The statements and clauses, in their usual order of use, include the following:
- SET statement
- CREATE VIEW statement
- SELECT statement
- FROM clause
- WHERE clause
- ORDER BY clause
- Batched statements
For details about the semantics and use of SQL queries, see SQL Query Language.
Build date: 9/10/2012