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:


DECLARE @String nvarchar(MAX)
DECLARE @ColDelimiter nvarchar(4000)
DECLARE @RowDelimiter nvarchar(4000)

SET @String = 'From City,To City,Distance In Miles'
		 + CHAR(13) + 'Minneapolis,Dallas,864.89'
		 + CHAR(13) + 'New York City,San Francisco,2568.57'

SET @ColDelimiter = ','
SET @RowDelimiter = CHAR(13)

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

DECLARE @String nvarchar(MAX)

DECLARE @ColDelimiter nvarchar(4000)

DECLARE @RowDelimiter nvarchar(4000)

SET @String = 'From City,To City,Distance In Miles'

+ CHAR(13) + 'Minneapolis,Dallas,864.89'

+ CHAR(13) + 'New York City,San Francisco,2568.57'

SET @ColDelimiter = ','

SET @RowDelimiter = CHAR(13)

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

<table>

<tr>

<td>Distance In Miles</td>

</tr>

<tr>

<td>Minneapolis</td>

<td>Dallas</td>

</tr>

<tr>

<td>San Francisco</td>

</tr>

</table>



String_To_HtmlTable

Featured API Wrapper Code / SQL Server