SQL语句查询结果由纵向 变列向 怎么变比如查询显示

试试这个存储过程:
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+',sum(case name when '''+name+''' then num else 0 end) '+name
from table1 group by name
set @sql=right(@sql,len(@sql)-1)
exec('select '+@sql+' from table1')