大家帮忙看看这个SQL错在那里?
declare @str varchar(1000),@num int,@titles varchar(100)
set @str='6,7,8,9,'
set @num=0
while(@str!='')
begin
select * from help where id=convert(int,substring(@str,@num,charindex(@str,',')))
--set @titles=substring(@str,@num,charindex(@str,','))
--print @titles
set @num=convert(int,charindex(@str,','))+1
set @str=substring(@str,charindex(@str,',')+1,len(@str)-1)
end
我是想分别得到 6 7 8 9的值,大家看看如何修改,谢谢!