Extensions to SQL for Indexing Service
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.
The SQL query language includes extensions to the standard SQL data manipulation language (DML) for querying the indexed contents of Indexing Service catalogs. Conceptually, the SQL query language considers a catalog to be a table with columns containing properties and rows containing documents. (For additional details, see Representing the Catalog Conceptually.) The extensions include the following.
The SQL extensions for Indexing Service do not support cross-data source queries. You need to issue separate queries to another source — for example, the ODBC Provider to Microsoft SQL Server™ — when combining information from more than one source.