SQL 分割符有关问题

create table wanglejun(电话号码 varchar(50))insert into wanglejun select '13478908796,12345678,11111'-- 拆分为行select '电话号码'+cast(row_number() over(order by getdate()) as varchar) '电话号码',substring(a.电话号码,b.number,charindex(',',a.电话号码+',',b.number)-b.number) 'n'from wanglejun ainner join master.dbo.spt_values bon b.[type]='P' and substring(','+a.电话号码,b.number,1)=','电话号码             n---------------- -----------------电话号码1          13478908796电话号码2          12345678电话号码3          11111(3 row(s) affected)-- 拆分为列with t as(select '电话号码'+cast(row_number() over(order by getdate()) as varchar) '电话号码',substring(a.电话号码,b.number,charindex(',',a.电话号码+',',b.number)-b.number) 'n'from wanglejun ainner join master.dbo.spt_values bon b.[type]='P' and substring(','+a.电话号码,b.number,1)=',')select [电话号码1], [电话号码2], [电话号码3]from tpivot(max(n) for 电话号码 in ([电话号码1], [电话号码2], [电话号码3])) t电话号码1      电话号码2    电话号码3------------  ----------  -----------13478908796      12345678     11111(1 row(s) affected)