declare @col varchar(1000)
set @col='13478908796,12345678,11111'
select substring(@col,number,charindex(',',@col+',',number+1)-number) from master..spt_values
where type='p' and number<=len(@col) and substring(@col,number,1)<>',' and substring(','+@col,number,1)=','
/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
13478908796
12345678
11111(3 行受影响)*/
set @col='13478908796,12345678,11111'
select substring(@col,number,charindex(',',@col+',',number+1)-number) from master..spt_values
where type='p' and number<=len(@col) and substring(@col,number,1)<>',' and substring(','+@col,number,1)=','
/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
13478908796
12345678
11111(3 行受影响)*/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货