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. |