复制代码 代码如下:
create function dbo.f_splitstr(
@str varchar(8000)
)returns @r table(id int identity(1, 1), value varchar(5000))
as
begin
/* function body */
declare @pos int
set @pos = charindex(‘,’, @str)
while @pos > 0
begin
insert @r(value) values(left(@str, @pos – 1))
select
@str = stuff(@str, 1, @pos, ”),
@pos = charindex(‘,’, @str)
end
if @str > ”
insert @r(value) values(@str)
return
end
select * from f_splitstr(‘中,国,人’)