Sql Server数据库小组 / 经典cte，将逗号分隔的字符串拆分成一个一列表

declare @s varchar(1000)
select @s = 'a,b,cd,ef,zzz,hello';
with csvtbl(i,j)
as(
 select i=1, j=charindex(',',@s+',')
 union all
 select i=j+1, j=charindex(',',@s+',',j+1)
 from csvtbl 
 where charindex(',',@s+',',j+1) <> 0
)
select col = substring(@s,i,j-i) from csvtbl