Extensions for Queries
The following table summarizes the extensions to the SQL syntax for specifying queries to Indexing Service.
| SQL Extension | Description |
|---|---|
|
Defines the column name and a data type for a property. | |
|
Sets the document ranking method used for the results of queries. | |
|
Creates a temporary view using column names and scope. | |
|
Defines permanent views using standard Indexing Service properties. | |
|
Selects all columns in a predefined or temporary view. | |
|
Defines the server, catalog, and path to use to create a virtual table of rows of documents. | |
|
Enables comparison of multivalued Indexing Service properties. | |
|
Enables comparison of columns with literal data using relational operators. | |
|
Similar to the LIKE predicate, but enables grouping matches against more than one pattern. | |
|
Enables setting and executing several SQL statements as one command. |