SQL Features Unavailable in Windows SharePoint Services Search

  • Article

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Windows SharePoint Services 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 Windows SharePoint Services 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

Reference

SQL Extensions in Windows SharePoint Services Search

Concepts

Windows SharePoint Services Search SQL Query Language Information