String_To_HtmlTable

Converts delimited data string (such as CSV) to an HTML Table

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

Syntax:

SELECT SQLHTTP.net.String_To_HtmlTable ( @String, @ColDelimiter, @RowDelimiter )

Arguments:

Name Type Description
@String nvarchar(MAX) String expression containing substrings and delimiters
@ColDelimiter nvarchar(4000) One or more characters to be used as a column separator
@RowDelimiter nvarchar(4000) One or more characters to be used as a row separator

Return Type:

xml

Sample Usage:

This example demonstrates converting the content of a comma-delimited string to an HTML Table:

See Also: