HtmlNodeCount

Returns the highest available Index that can be used using the HTMLNode function.

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

Syntax:

SELECT SQLHTTP.net.HtmlNodeCount ( @Html, @Xpath )

Arguments:

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



Return Type:

int



Sample Usage:


DECLARE @Html nvarchar(MAX)
DECLARE @Xpath nvarchar(MAX)
 
SET @Html = N'
<table align="center">
    <thead>
        <tr>
            <th>Year</th>
            <th>Start date</th>
            <th>Ending date</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>2017</td>
            <td>March 12</td>
            <td>November 5</td>
        </tr>
        <tr>
            <td>2018</td>
            <td>March 11</td>
            <td>November 4</td>
        </tr>
        <tr>
            <td>2019</td>
            <td>March 10</td>
            <td>November 3</td>
        </tr>
        <tr>
            <td>2020</td>
            <td>March 8</td>
            <td>November 1</td>
        </tr>
    </tbody>
</table>'
 
SET @Xpath = N'//tr'
 
SELECT SQLHTTP.net.HtmlNodeCount(@Html, @Xpath)

DECLARE @Html nvarchar(MAX)

DECLARE @Xpath nvarchar(MAX)

SET @Html = N'

<thead>

<tr>

<th>Start date</th>

<th>Ending date</th>

</tr>

</thead>

<tbody>

<tr>

<td>March 12</td>

<td>November 5</td>

</tr>

<tr>

<td>March 11</td>

<td>November 4</td>

</tr>

<tr>

<td>March 10</td>

<td>November 3</td>

</tr>

<tr>

<td>March 8</td>

<td>November 1</td>

</tr>

</tbody>

</table>'

SET @Xpath = N'//tr'

SELECT SQLHTTP.net.HtmlNodeCount(@Html, @Xpath)

------



HtmlNodeCount

Featured API Wrapper Code / SQL Server