sql server 自定义split(分割)函数

ALTER function [dbo].[split] ( @SourceSql varchar(8000), @StrSeprate varchar(10) ) returns @temp table(F1 varchar(100)) as begin declare @i int set @SourceSql = rtrim(ltrim(@SourceSql)) set @i = charindex(@StrSeprate,@SourceSql) while @i >= 1 begin if len(left(@SourceSql,@i-1))>0 begin insert @temp values(left(@SourceSql,@i-1)) end set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i) set @i=charindex(@StrSeprate,@SourceSql) end if @SourceSql <> '' insert @temp values(@SourceSql) return end ---------------------------------------- //应用 --开始迭代分割出来的参数 declare @str nvarchar(10) declare auth_cur cursor for select F1 from split(要分割的参数,'分隔符') open auth_cur fetch next from auth_cur into @str while ( @@fetch_status = 0 ) begin //做处理 end close auth_cur deallocate auth_cur