xmltable

Extracts data from an XML document and returns it as a SQL table.

Usage

See XML Services for syntax, examples, and usage information for xmltable and all other Transact-SQL functions that support XML in the database.