Export (0) Print
Expand All

SQL Syntax Changes from SharePoint Portal Server 2003

Last modified: April 21, 2010

Applies to: SharePoint Server 2010

Microsoft SharePoint Server 2010 search supports Microsoft SQL Server full-text search syntax, so most search queries written for earlier versions will continue to work after upgrading to SharePoint Server search. However, there are changes in the syntax, and support for some SQL syntax elements is removed or deprecated.

The following table lists and describes the changes.

Element

Description

COALESCE_TABLE function

Removed. Queries using this function must be rewritten.

Column weighting

Removed. If present in queries to SharePoint Server search, it is ignored.

RANK BY clause

Removed. If present in queries to SharePoint Server search, it is ignored.

UNION ALL specification

Removed. If present in queries to SharePoint Server search, it is ignored.

MATCHES predicate

Removed. Queries using this predicate must be rewritten.

FROM <scope>

Specifying a search scope in the FROM clause is no longer supported.

SharePoint Server search supports only the following FROM clause syntax:

…FROM scope()…

CAST

Removed. Queries using this function must be rewritten.

Show:
© 2014 Microsoft