SQL Server splits strings (implements split)

The script that implements the string Decomposition Method in SQL Server is as follows: Create Function [DBO]. [fn_splitstr] (@ sourcesql varchar (max), -- string @ strseprate varchar (10) -- Characters Used for decomposition) 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 insert @ temp values (left (@ sourcesql, @ i-1) set @ sourcesql = substring (@ sourcesql, @ I + 1, Len (@ sourcesql) -@ I) set @ I = charindex (@ strseprate, @ sourcesql) end if @ sourcesql <> ''insert @ temp values (@ sourcesql) return end