declare @ss varchar(50)
set @ss='1A,1B,2,3,4'create table #t (s varchar(100))
set @ss='insert #t select ' + replace(@ss,',',' union select ')
exec(@ss)--得到长度:
select count(*) from #tdrop table #t
set @ss='1A,1B,2,3,4'create table #t (s varchar(100))
set @ss='insert #t select ' + replace(@ss,',',' union select ')
exec(@ss)--得到长度:
select count(*) from #tdrop table #t
set @ss='1A,1B,2,3,4,2'
set @sql='select '''+replace(@ss,',',''' col union all select ''')+''' col'
exec('select count(distinct col) from ('+@sql+') t')