Share via

SQL Features Unavailable in SharePoint Foundation Search

  • Article

[This documentation is preliminary and is subject to change.]

Microsoft SharePoint Foundation 2010 Search supports a query language based on SQL; however, it does not search in a relational database with user-defined tables or indexes. Because of this, many standard SQL statements and syntax features do not apply. The following is a list of the more significant SQL features that are not supported in SharePoint Foundation 2010 Search.

  • CONVERT()

  • CREATE VIEW statement

  • Data definition language

  • DATASOURCE statement

  • Date and Time formats other than ISO date and time stamp

  • Derived columns using AVG(), COUNT(), MAX(), MIN(), SUM(), or other calculations

  • GRANT statement

  • Hierarchical rowsets

  • Information schema

  • INSERT statement

  • OLE DB data types

  • SQL-standard regular expressions (use CONTAINS, LIKE, and MATCHES instead)

  • Parameters to SQL queries

  • Relational column comparison

  • Revision ID header

  • REVOKE statement

  • SCOPE aliases or revision numbers

  • SELECT ALL (removes duplicates automatically)

  • Stored procedures

  • Structured document expansion

  • UNKNOWN keyword

  • UPDATE statement

  • BATCH statements

See Also

Concepts

SharePoint Foundation Search SQL Query Language Information

Reference

SQL Extensions in SharePoint Foundation Search