declare @var varchar(40)
set @var=',3701,7207,26601,10,'create table #g(a bigint)
set @var=replace(stuff(left(@var,len(@var)-1),1,1,''),',',' union all select ')
exec('insert #g select '+@var)
select * from #g
set @var=',3701,7207,26601,10,'create table #g(a bigint)
set @var=replace(stuff(left(@var,len(@var)-1),1,1,''),',',' union all select ')
exec('insert #g select '+@var)
select * from #g
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货