GlobalTable_To_HtmlTable

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

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

Syntax:

EXEC SQLHTTP.net.GlobalTable_To_HTMLTable @GlobalTableName, @HTMLTable OUTPUT

Arguments:

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: