SQL Server parses string table value functions

In databases, strings in certain formats are often used for parsing. I have previously written a similar method, and today I have written another one, and I will share it with you.

Create Function [DBO]. [func_splitstringtotable] (-- string to be parsed @ STR nvarchar (max), -- separator @ split varchar (10) returns @ t table (C1 varchar (100 )) asbegin declare @ I int declare @ s int set @ I = 1 Set @ s = 1 while (@ I> 0) Begin set @ I = charindex (@ split, @ STR, @ s) if (@ I> 0) Begin insert @ T (C1) values (substring (@ STR, @ s, @ I-@ s )) end else begin insert @ T (C1) values (substring (@ STR, @ s, Len (@ Str)-@ s + 1 )) end set @ s = @ I + 1 end return end

The usage is as follows:

Select * From DBO. func_splitstringtotable ('1, 15,13 ',',');