Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » XML in the database » Ways to import XML documents as relational data


XML import using the OPENXML operator

The OPENXML operator is used in the FROM clause of a query to generate a result set from an XML document. OPENXML uses a subset of the XPath query language to select nodes from an XML document.

 Using XPath expressions
 Generating a result set using OPENXML
 Using OPENXML to generate an edge table
 Using OPENXML with xp_read_file
 Querying XML in a column
 See also