项目中碰到字符串分解问题,做一个简单的例子来标记一下
1
declare @ids varchar(300)
2set @ids='1,3,4'
3if(right(@ids,1)<>',')
4begin
5 set @ids=@ids +','
6end
7declare @Id int
8while CHARINDEX(',',@ids)>0
9begin
10 SELECT @Id=LEFT(@ids,CHARINDEX(',',@ids+',')-1),@ids=STUFF(@ids,1,CHARINDEX(',',@ids+','),'')
11 print @id
12end
declare @ids varchar(300)2
set @ids='1,3,4'3
if(right(@ids,1)<>',')4
begin5
set @ids=@ids +','6
end7
declare @Id int8
while CHARINDEX(',',@ids)>09
begin10
SELECT @Id=LEFT(@ids,CHARINDEX(',',@ids+',')-1),@ids=STUFF(@ids,1,CHARINDEX(',',@ids+','),'')11
print @id12
end