SELECT Statement

Use the SELECT statement to retrieve rows. The SELECT statement specifies the columns of interest, the scope (the set of files) for the search, and the search criteria. If the results must be ordered, you can add an additional ORDER BY clause to return the rows in ascending or descending order.

Syntax

SELECT  Select_List  | *
        FROM_Clause 
        [WHERE_Clause ]
        [ORDER_BY_Clause ]

Elements

Remarks

SQL-92 specifies both the ALL and DISTINCT set quantifiers. Because Index Server retrieves all rows (files) including duplicates, the ALL set quantifier is assumed and does not have to be specified. DISTINCT is not supported.

Examples

1. The following query returns the author, size, title, and the last time the file was modified, for all files on the virtual root ( / ) that contain the phrase "Index Server".

   SELECT DocAuthor, size,  DocTitle,  write
   FROM  SCOPE()
   WHERE CONTAINS(Contents, '"Index Server"') > 0

2. For the following query to work, #MyDocView must have first been defined with a CREATE VIEW statement. Suppose #MyDocView was defined as a VIEW containing the properties DocAuthor, FileName, size, and access. Using an asterisk selects all the properties in that VIEW. The statement returns DocAuthor, FileName, size, and access values for all rows where the file size is greater than 100000.

   
   SELECT * FROM #MyDocView WHERE size > 100000

© 1997 by Microsoft Corporation. All rights reserved.