怎么没有循环执行呢?
create function func_cut (@s varchar(4000))
returns varchar(4000)
begin
declare @i int,@n int
declare @ss varchar(4000),@tt varchar(4000)
select @ss='',@tt=@s
select @n=1
while @n<=3
begin
select @i=charindex('/',@tt)
if @i=0
break
else
select @ss=@ss+right(@tt,len(@tt)-@i)
select @n=@n+1
break
end
return @ss
end
select dbo.func_cut('3454543/3434/23423/34234/54/54/23/34')
drop function func_cut
结果是:3434/23423/34234/54/54/23/34 为什么不是34234/54/54/23/34 呢?