SELECT Statement in SharePoint Search SQL Syntax
Last modified: April 21, 2010
Applies to: SharePoint Server 2010
Defines in the first clause of statement the columns to return in the rowset.
SELECT <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.
Note
|
|---|
|
SharePoint Server search 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). |
Note