declare @s varchar(100)
set @s=',1,2,3,'
SELECT b.v into #temp FROM
(SELECT CAST('<r>' + REPLACE(@s,',','</r><r>') + '</r>' AS XML) x) a
CROSS APPLY
(SELECT v=t.x.value('.','VARCHAR(10)') FROM a.x.nodes('//r') AS t(x) ) bdeclare @str varchar(800)
set @str=''
select @str=@str+','+v from #temp where v<>''
print @str
select stuff(@str,1,1,'')----
1,2,3
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货