Share via


SET Statement in Windows SharePoint Services Search SQL Syntax

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Used to specify certain options for the query. The options that you can specify using the SET statement are PROPERTYNAME and RANKMETHOD.

PROPERTYNAME

You can associate a property with a friendly alias for the query, using the following syntax:

SET PROPERTYNAME <guid_format>

PROPID <property_id> | <property_name>

AS <column_alias> [<type_clause>]

RANKMETHOD

You can specify the rank method for queries with the ISABOUT term, using the following syntax:

SET RANKMETHOD <rankmethod>

Note

The RANKMETHOD methods that can be specified using the SET statement are JACCARD COEFFICIENT, DICE COEFFICIENT, and INNER PRODUCT. For more information about these methods, see RANKMETHOD Term in Windows SharePoint Services Search SQL Syntax.

See Also

Concepts

Windows SharePoint Services Search SQL Syntax