如何在SQL Server中拆分字符串

SELECT value FROM STRING_SPLIT('a,b,c', ',');

CREATE FUNCTION SplitString
(
    @Input NVARCHAR(MAX),
    @Delimiter NVARCHAR(255)
)
RETURNS TABLE
AS
RETURN
(
    SELECT
        [Value] = SUBSTRING(
            @Input,
            [Number] = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),
            CHARINDEX(@Delimiter, @Input + @Delimiter, [Number]) - [Number]
        )
    FROM (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10) T1(N)
    WHERE [Number] <= LEN(@Input)
        AND SUBSTRING(@Delimiter + @Input, [Number], DATALENGTH(@Delimiter)) = @Delimiter
);

SELECT [Value] FROM SplitString('a,b,c', ',');

DECLARE @Input NVARCHAR(MAX) = 'a,b,c';
DECLARE @XML XML = CAST('<root><r>' + REPLACE(@Input, ',', '</r><r>') + '</r></root>' AS XML);

SELECT
    T.c.value('.', 'NVARCHAR(MAX)') AS [Value]
FROM
    @XML.nodes('/root/r') T(c);