sqlserver2005分割字符串,循环输出示例

create function f_splitstr(@source varchar(500),@split

varchar(5))

returns @temp table(tid varchar(50))

as

begin

declare @ch as varchar(50)

set @source=@source+@split

while(@source<>'')

begin

set @ch=left(@source,charindex(',',@source,1)-1)

insert @temp values(@ch)

set @source=stuff(@source,1,charindex(',',@source,1),'')

end

return

end

--select tid from dbo.f_splitstr('xxxxxxx,ttttt,yyyyyy,ererer',',') --select getdate()

declare

@i int,@countNum int,

@para varchar(50)

declare tid_cursor CURSOR for select tid from

dbo.f_splitstr('xxxxxxx,ttttt,yyyyyy,ererer',',')

open tid_cursor

FETCH NEXT FROM tid_cursor into @para

WHILE@@FETCH_STATUS= 0

BEGIN

print @para

FETCH NEXT FROM tid_cursor into @para

END;

CLOSE tid_cursor

DEALLOCATE tid_cursor

GO