SQL Server字符串拆分为列

SELECT value
FROM STRING_SPLIT('apple,banana,orange', ',');

CREATE FUNCTION dbo.SplitStringToColumns
(
    @inputString VARCHAR(MAX),
    @delimiter CHAR(1)
)
RETURNS @outputTable TABLE (value VARCHAR(MAX))
AS
BEGIN
    DECLARE @startPos INT, @endPos INT

    SET @startPos = 1
    SET @endPos = CHARINDEX(@delimiter, @inputString)

    WHILE @endPos > 0
    BEGIN
        INSERT INTO @outputTable (value)
        SELECT SUBSTRING(@inputString, @startPos, @endPos - @startPos)

        SET @startPos = @endPos + 1
        SET @endPos = CHARINDEX(@delimiter, @inputString, @startPos)
    END

    INSERT INTO @outputTable (value)
    SELECT SUBSTRING(@inputString, @startPos, LEN(@inputString) - @startPos + 1)

    RETURN
END

SELECT value
FROM dbo.SplitStringToColumns('apple,banana,orange', ',');