declare @string varchar(1000)
set @string='aaaa,bbbb,cccc,dddd'creart table #a (a varchar(8000))
set @string='insert #a select * from (select '''+replace(@string,',','''as str union all select ''')+''') a'
exec(@string)select * from #adrop table #a
set @string='aaaa,bbbb,cccc,dddd'creart table #a (a varchar(8000))
set @string='insert #a select * from (select '''+replace(@string,',','''as str union all select ''')+''') a'
exec(@string)select * from #adrop table #a
set @string='aaaa,bbbb,cccc,dddd'create table #a (a varchar(8000))
set @string='insert #a select * from (select '''+replace(@string,',','''as str union all select ''')+''') a'
exec(@string)select * from #adrop table #a
比如象charindex()len()
set @aa='aaaa,bb,ca s a'set @bb=0
set @cc=charindex(',',@aa)
select substring(@aa,@bb,@cc-@bb)
while @cc>0
begin
set @bb=@cc+1
set @cc=charindex(',',@aa,@bb)
select substring(@aa,@bb,case when @cc>0 then @cc-@bb else len(@aa) end)
end