declare @string varchar(1000)
create table # (a int)
set @string='89000+90000+89999'
set @string='insert # select * from (select '''+replace(@string,'+','''as str union all select ''')+''') a'
exec(@string)
select * from #
drop table #??
create table # (a int)
set @string='89000+90000+89999'
set @string='insert # select * from (select '''+replace(@string,'+','''as str union all select ''')+''') a'
exec(@string)
select * from #
drop table #??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货