请教一下将存储的东西写为函数

[freescy2002]

以下开始－－
declare @sql varchar(8000)
select
@sql=isnull(@sql+',','')
+'sum(case when b='+ltrim(b)+' then c else 0 end) as ['+ltrim(b)+']'
from
(select distinct b from tb) t
这里结果－－

exec('select a,'+@sql+' from tb group by a')

能否将最上面的部分写一个函数，将 '+@sql+' 以函数的方式来实现，谢谢 如

select a,dbo.abc() from tb group by a

[百年树人]

函数不支持动态SQL，建议用存储过程来做

[黄_瓜]

[Quote=引用 1 楼 josy 的回复:]
函数不支持动态SQL，建议用存储过程来做
[/Quote]
up

[黄_瓜]

create proc pp 
as
begin
declare @sql varchar(8000)
select  
  @sql=isnull(@sql+',','')
  +'sum(case when b='+ltrim(b)+' then c else 0 end) as ['+ltrim(b)+']'
from
(select distinct b from tb) t
exec('select a,'+@sql+' from tb group by a')
end
go

exec pp