SQL Syntax Changes from SharePoint Portal Server 2003
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. |
See Also
Reference
SQL Features Unavailable in SharePoint Search
SQL Extensions in SharePoint Search
FROM Clause in SharePoint Search SQL Syntax
SELECT Statement in SharePoint Search SQL Syntax