Constructs an HTML Table from tabular data in a global temporary table

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


EXEC @GlobalTableName, @HtmlTable OUTPUT


Name Type Description
@GlobalTableName varchar(100) Name of a Global Temporary Table that has been created and populated with data
@HtmlTable xml Output parameter. nvarchar(MAX)

Return Type:

See the @HtmlTable output parameter

Sample Usage:

This example demonstrates copying the content of a view (OLEDBProviders) into a global temporary table which is then used to construct an HTML Table:

See Also: