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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Using XML in the database » Importing XML documents as relational data

 

Importing XML using openxml

The openxml procedure 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