sqlserver 建一个分割函数

可以将字符串

"A02ZDBC001,A02ZDBC005" 分割成 "A02ZDBC001","A02ZDBC005"

ALTER FUNCTION dbo.SplitString
(
    @String NVARCHAR(MAX),
    @Delimiter CHAR(1)
)
RETURNS @Result TABLE (Value NVARCHAR(MAX))
AS
BEGIN
    DECLARE @Value NVARCHAR(MAX);

    WHILE CHARINDEX(@Delimiter, @String) > 0
    BEGIN
        SET @Value = LEFT(@String, CHARINDEX(@Delimiter, @String) - 1);
        INSERT INTO @Result (Value) VALUES (@Value);
        SET @String = RIGHT(@String, LEN(@String) - CHARINDEX(@Delimiter, @String));
    END

    INSERT INTO @Result (Value) VALUES (@String);
    RETURN;
END;