SQL 分隔字符串 以每列显示数据

编辑器加载中...

DECLARE @c  varchar(10)
DECLARE @split varchar(10)
set @c='a,b,c,d,e'
set @split   =','

declare @sql varchar(200)
set @sql='select '
declare @i int
set @i=1
while(charindex(@split,@c)<>0)  
        begin 
          set @sql =@sql+''''+ substring(@c,1,charindex(@split,@c)-1)+ '''' + ' as 字段'+convert(varchar(5),@i)
          if(charindex(@split,@c)!=len(@c)-1)
            begin            
                set @sql =@sql +', '
            end
          --print substring(@c,1,charindex(@split,@c)-1)  
          set   @c   =   stuff(@c,1,charindex(@split,@c),'') 
          set @i=@i+1
        end 
--print @sql
exec(@sql)