Which query language is used by the OLEDB Indexing Server provider?
The MSIDXS provider supports the SQL query language which is well known and makes it very easy to query the Indexing Server. It only allows to query, so does not support any updates, inserts or deletes. The supported query syntax is slightly adapted for this provider. You can find detailed documentation here. The biggest difference is in the FROM clause. You can specify an existing view or the SCOPE() function. The Indexing Serve comes with the following pre-defined views. The referenced MSDN help page lists which fields are included in which view. We have for example used in the above query string the WEBINFO view. You are allowed to use a “SELECT * FROM view”, which you are not allowed to do when using the SCOPE() function. You can also create your own views by using the CREATE VIEW command.
