字符串切割

/*定义数据字符串*/
declare @sourcesql varchar(100),@middlesql varchar(50)
/*初始化字符串*/
set @sourcesql = '4001,4002,4003,4004'
/*循环提取以 ',' 分割都字符内容*/
while(charindex(',',@sourcesql,1) > 0 )
begin
 /*输出显示各个字符串的值*/
 select left(@sourcesql,charindex(',',@sourcesql,1) - 1)
 select @sourcesql = stuff(@sourcesql,1,charindex(',',@sourcesql,1),'')
end
select @sourcesql