HtmlNodes

Retrieves HTML Nodes via XPath query and returns a table

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

Syntax:

SELECT *
FROM SQLHTTP.net.HTMLNode ( @Html, @Xpath )

Arguments:

Name Type Description
@Html nvarchar(MAX) String containing HTML
@Xpath nvachar(MAX) An Xpath query

Table Returned:

Column name Data type Description
RowID int Node Index
HTMLNode nvarchar(MAX) Node Content

Sample Usage:

See Also: