SQL将查询内容输出为html表格

 1 CREATE PROCEDURE [dbo].[QUERY_TABLE](@conn varchar(200),@title varchar(200),@desc varchar(max),@query nvarchar(max),@link_ref nvarchar(max),
 2         @html nvarchar(max) output)
 3 AS
 4 BEGIN
 5     -- SET NOCOUNT ON added to prevent extra result sets from
 6     -- interfering with SELECT statements.
 7     SET NOCOUNT ON;
 8 
 9     -- Insert statements for procedure here
10     -- @link_ref: default delimiter is colon.
11 
12     if object_id('tempdb..##t') is not null drop table ##t
13 
14     declare @exec_query nvarchar(max)
15     set @exec_query='select * into ##t from openrowset(''SQLOLEDB'','''+@conn+''',''SET FMTONLY OFF; SET NOCOUNT ON; '+replace(@query,'''','''''')+''') a'
16     exec sp_executesql @exec_query