Xml_To_NodeTable

Returns tabular hierarchical data representation of an XML

  • Free Function
  • SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT *
FROM SQLHTTP.net.XML_To_NodeTable( @Xml )

Arguments:

Name Type Description
@Xml xml An XML to be shredded into a table

Table Returned:

See NodeTable for detailed table structure documentation

Sample Usage:

See Also: