HtmlNodeChildren

Returns a table containing child nodes of an HTML Node

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

Syntax:

SELECT *
FROM SQLHTTP.net.HtmlNodeChildren ( @HtmlNode )

Arguments:

Name	Type	Description
@HtmlNode	nvarchar(MAX)	String containing an HTML node



Table Returned:

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



Remarks:

Note that line breaks are presented as separate nodes



Sample Usage:


DECLARE @HtmlNode nvarchar(MAX)
SET @HtmlNode = '<div>
		<img src="image.png" alt="Logo">
		<span>Sample Text</span>
	</div>'
	
SELECT *
FROM SQLHTTP.net.HtmlNodeChildren(@HtmlNode)

DECLARE @HtmlNode nvarchar(MAX)

SET @HtmlNode = '<div>

<span>Sample Text</span>

</div>'

SELECT *

FROM SQLHTTP.net.HtmlNodeChildren(@HtmlNode)

RowID HTMLNode

----------- ------------------------------------------------

2 <img src="image.png" alt="Logo">

4 <span>Sample Text</span>



HtmlNodeChildren

Featured API Wrapper Code / SQL Server