xmltable

Description

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

See also

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