SQL Syntax Changes from SharePoint Portal Server 2003
Enterprise Search in Microsoft Office SharePoint Server 2007 supports Microsoft SQL Server full-text search syntax, so most search queries written for Microsoft Office SharePoint Portal Server 2003 will continue to work after upgrading to Enterprise Search in Microsoft Office SharePoint Server 2007. 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 Enterprise Search, it is ignored. |
RANK BY clause |
Removed. If present in queries to Enterprise Search, it is ignored. |
UNION ALL specification |
Removed. If present in queries to Enterprise 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. Enterprise Search supports only the following FROM clause syntax:
|
CAST |
Removed. Queries using this function must be rewritten. |
See Also
Reference
FROM Clause in Enterprise Search SQL Syntax
SELECT Statement in Enterprise Search SQL Syntax
Concepts
Upgrading SharePoint Portal Server Search 2003 Customizations to Enterprise Search