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
SQL将查询内容输出为html表格
最新推荐文章于 2024-06-13 21:12:59 发布