SQLSERVER2008 存储过程丢入任何sql返回查询结果默认首行列名

执行SQL语句

SAV_P_SELSQL'select * from SAV_IO_部门信息 group by  部门名称,部门ID,排序','部门名称,部门ID,排序'

---

查询结果

---

存储过程代码

CREATE  PROCEDURE [dbo].[SAV_P_SELSQL]
(
-- 任意SQL 但是不能包含order by
	@d_sql 	varchar(max),
-- 用于order by 排序 列名
	@f_sql 	varchar(max)
)
As
declare  @c_Sql as varchar(max)
declare  @r_Sql as varchar(max)
declare  @cTmp1 as varchar(max)
declare  @c_RowName as varchar(max)
set @c_RowName=''
Set @c_Sql=''
 
set @r_Sql= 'select  * into ##sav_a from ('+@d_sql+') as a order by '+@f_sql 


 
--将查询结果缓存到全局变量中
exec(@r_Sql)
select * into #sav_a  from ##sav_a
drop table ##sav_a
--从全局变量中获取临时表的列名
select   name  into #b    from      tempdb.dbo.syscolumns      where      id=object_id('tempdb..#sav_a') 
	Begin
		select  name into #CowA from #b 
		Declare my_cursor cursor scroll dynamic for select name from #CowA 
		open my_cursor
		fetch next from my_cursor into @cTmp1
		while(@@fetch_status=0)
		  begin
			if @cTmp1 is not null
				Begin	
				--拼接查询的列名
					set @c_Sql=@c_Sql+',casT('+@cTmp1+' as varchar(Max))'
				--拼接首行列名用于union all
				    set @c_RowName=@c_RowName+''''+','+''''+@cTmp1+''''+' AS '+''''+@cTmp1
		    			fetch next from my_cursor into @cTmp1
				end
		  end 
		close my_cursor
		deallocate my_cursor
		set @c_sql='Select '+substring(@c_sql,2,len(@c_sql))+' FROM #sav_a'
	 	set @c_sql= 'select '+ substring(@c_RowName,3,len(@c_RowName))+''''+' union all '+@c_sql
		Exec(@c_sql)
		drop table #CowA
		drop table #sav_a
		drop table #b
	End


GO

---