Data Manipulation Operators

Note

Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.

 

The following topics describe the semantics of the data manipulation operators, including their inputs and outputs:

• Constants, Identifiers, Names, and Parameters
• Constructors and Coercion perators
• Operators on Tables
• Operators with Two Variants for Ordered and Non-Ordered Tables
• Operators for Ordered Tables
• Operators for Hierarchical Tables
• Comparison Operators
• Operators for Scalars
• Content Search Operators
• Update Operators
• Aggregate Functions
• Mixed Operators
• Special Operators
• Operators for AddPostProcessing Method
• Lists of Arguments