declare @s varchar(1000)
set @s = '1,2,3'while charindex(',',@s)>0
begin
insert into aa(value) select substring(@s,charindex(',',@s)-1)
set @s = stuff(@s,1,charindex(',',@s)-1,'')
endinsert into aa(value) select @s
set @s = '1,2,3'while charindex(',',@s)>0
begin
insert into aa(value) select substring(@s,charindex(',',@s)-1)
set @s = stuff(@s,1,charindex(',',@s)-1,'')
endinsert into aa(value) select @s
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货