HtmlTables

Retrieves HTML Tables from an HTML string and returns a table

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

Syntax:

SELECT *
FROM SQLHTTP.net.HTMLTables ( @Html )

Arguments:

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

Table Returned:

Column name Data type Description
RowID int Row Index
ParentRowID int The RowID of the containing (parent) table, if any.
StartPosition int Start position of the <table> tag
EndPosition int End position of the </table> tag
HTMLTable nvarchar(MAX) Content

Sample Usage:

See Also: