HtmlNodeAttribute

Retrieves the value of an HTML Node Attribute

Syntax:

SELECT SQLHTTP.net.HtmlNodeAttribute ( @HtmlNode, @Name )

Arguments:

Name	Type	Description
@HtmlNode	nvarchar(MAX)	String containing an HTML element node
@Name	nvarchar(MAX)	Name of the Attribute to be retrieved

Return Type:

nvarchar(MAX)

Sample Usage:


DECLARE @HtmlNode nvarchar(MAX)
SET @HtmlNode = N'<img src="image.png" alt="Logo" />'

SELECT SQLHTTP.net.HtmlNodeAttribute(@HtmlNode, 'src')

DECLARE @HtmlNode nvarchar(MAX)

SET @HtmlNode = N'<img src="image.png" alt="Logo" />'

SELECT SQLHTTP.net.HtmlNodeAttribute(@HtmlNode, 'src')

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

image.png