Share via


SELECT Statement in Windows SharePoint Services Search SQL Syntax

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.

The first clause of the SELECT statement defines which columns to return in the rowset.

SELECT <columns> …

Remarks

You specify what information to return in the <columns> specification. You must specify at least one column of information to retrieve.

Note Search in Windows SharePoint Services does not support using column aliases.

Specifying Query Columns

Following is the columns portion of the SELECT clause syntax:

<column> [ {, <column>} … ]

Separate multiple column specifiers by using commas. Column names can be either regular or delimited identifiers. When the query returns a document that does not have the requested column, the value of that column for the document is NULL.

In the SQL query, you are allowed to use the asterisk (*) to specify that all columns in a table are to be returned. However, no defined and fixed set of properties applies to all documents. For this reason, the SQL asterisk is not permitted in the <columns> setting.

NoteSearch in Windows SharePoint Services does not support the following:

  • Column aliasing.

  • Casting the column data type as it is returned in the query.

  • Limiting the column length, the full length of each text property is returned.

See Also

Reference

FROM Clause in Windows SharePoint Services Search SQL Syntax

WHERE Clause in Windows SharePoint Services Search SQL Syntax

Overview of the Windows SharePoint Services Search Query