Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SQL Features Unavailable in SharePoint Search

Last modified: April 21, 2010

Applies to: SharePoint Server 2010

Microsoft SharePoint Server 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.

Following is a list of the more significant SQL features that are not supported in SharePoint Server search.

  • CONVERT() (use the CAST functions instead)

  • CREATE VIEW statement

  • Data definition language (DDL)

  • 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

© 2015 Microsoft