一个拆分字符串的函数，和她的调用

create function f_split(@full varchar(8000),@split varchar(10)) returns @re table (col2 varchar(100))
as
begin
declare @splitlen int
set @splitlen=len(@split+'a')-2
while charindex(@split,@full)>0
begin
 insert @re values(left(@full,charindex(@split,@full)-1))
 set @full=stuff(@full,1,charindex(@split,@full)+@splitlen,'')
end
insert @re values(@full)
return
end

 

create table one
(
col1 int identity(1,1) ,
col2 varchar(50)
)

insert into one (col2)
select * from  dbo.f_split('a,b,c',',') union all
select * from  dbo.f_split('dt,st,ss,d',',')

select * from one