分拆字符串返回表

Create FUNCTION [dbo].[Split]  --不返回空行
(
 @SplitString VARCHAR(8000),-- nvarchar(4000)
 @Separator VARCHAR(2) = ','
)
RETURNS @SplitStringsTable TABLE
(
 [id] INT IDENTITY(1,1),
 [value] VARCHAR(8000)-- nvarchar(4000)
)
AS
BEGIN
    DECLARE @CurrentIndex INT;
    DECLARE @NextIndex INT;
    DECLARE @ReturnText VARCHAR(8000);-- nvarchar(4000)
    SELECT @CurrentIndex=1;
    WHILE(@CurrentIndex<=LEN(@SplitString)) 
    BEGIN
        SELECT @NextIndex=CHARINDEX(@Separator,@SplitString,@CurrentIndex);
        IF(@NextIndex=0 OR @NextIndex IS NULL)
            SELECT @NextIndex=LEN(@SplitString)+1;
        
        SELECT @ReturnText=SUBSTRING(@SplitString,@CurrentIndex,@NextIndex-@CurrentIndex);

        INSERT INT