在mssqlserver中 自定义函数 截取字符串并且返回一个table

create function f_splitstr

(

@SourceSql varchar(8000),

@strSeprate varchar(100)

)

returns @temp table (values varchar(100))

as

begin

declare @ch as varchar(100)

set @SourceSql=@SourceSql+@StrSeprate

while(@SourceSql<>'')

begin

set

@ch=left(@SourceSql,Charindex(',',@SourceSql,1)-1)

insert @temp values(@ch)

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

end

return

end

 

 

select * from f_splitstr('37710620,49210397',',')