SQL Syntax Changes from SharePoint Portal Server 2003
마지막 수정 날짜: 2010년 4월 21일 수요일
적용 대상: SharePoint Server 2010
Microsoft SharePoint Server 2010 검색 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 검색. 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 검색, it is ignored. |
RANK BY clause |
Removed. If present in queries to SharePoint Server 검색, it is ignored. |
UNION ALL specification |
Removed. If present in queries to SharePoint Server 검색, 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 검색 supports only the following FROM clause syntax: …FROM scope()… |
CAST |
Removed. Queries using this function must be rewritten. |
참고 항목
참조
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