Extensions for Queries

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 following table summarizes the extensions to the SQL syntax for specifying queries to Indexing Service.

SQL Extension	Description
SET PROPERTYNAME	Defines the column name and a data type for a property.
SET RANKMETHOD	Sets the document ranking method used for the results of queries.
CREATE VIEW #	Creates a temporary view using column names and scope.
Indexing Service Predefined Views Site Server Predefined Views	Defines permanent views using standard Indexing Service properties.
SELECT *	Selects all columns in a predefined or temporary view.
FROM SCOPE	Defines the server, catalog, and path to use to create a virtual table of rows of documents.
ARRAY predicate	Enables comparison of multivalued Indexing Service properties.
Comparison predicate	Enables comparison of columns with literal data using relational operators.
MATCHES predicate	Similar to the LIKE predicate, but enables grouping matches against more than one pattern.
Batched statements	Enables setting and executing several SQL statements as one command.