SQL Queries Supported by OLE DB Provider

This section describes the subset of ANSI SQL language used to manipulate objects aggregated across multiple data sources.

The following code example shows the SQL query syntax supported by the OLE DB Provider for Commerce Server:

SELECT select_list FROM class_name
   [WHERE search_condition] 
   [ORDER BY order_expression]

select_list ::= member_name | member_name , member_list
search_condition ::= in_exression | predicate | 
                     predicate AND search_condition
in_expression ::= member_name IN ( value1, … , valueN )
predicate ::= 
      member_name { = | <> | > | >= | < | <= | LIKE } value |
      member_name IS [NOT] NULL
order_expression::= member_name*

INSERT [INTO] class_name member_list VALUES value_list

member_list ::= member_name | member_name , member_list
value_list ::= value | value , value_list

UPDATE class_name SET member_value_list WHERE search_condition

member_value_list ::= member_value | member_value , member_value_list
member_value ::= member_name = value
DELETE [FROM] class_name WHERE search_condition

Copyright © 2005 Microsoft Corporation.
All rights reserved.