项目中碰到字符串分解问题,做一个简单的例子来标记一下
1declare @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
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