Sql拆分SQL SERVER 2019中带逗号的列

SELECT value
FROM STRING_SPLIT(column_name, ',')

CREATE FUNCTION dbo.SplitString
(
    @inputString NVARCHAR(MAX),
    @delimiter NVARCHAR(10)
)
RETURNS @outputTable TABLE (splitValue NVARCHAR(MAX))
AS
BEGIN
    DECLARE @value NVARCHAR(MAX)
    WHILE CHARINDEX(@delimiter, @inputString) > 0
    BEGIN
        SET @value = SUBSTRING(@inputString, 1, CHARINDEX(@delimiter, @inputString) - 1)
        INSERT INTO @outputTable (splitValue) VALUES (@value)
        SET @inputString = SUBSTRING(@inputString, CHARINDEX(@delimiter, @inputString) + LEN(@delimiter), LEN(@inputString))
    END
    INSERT INTO @outputTable (splitValue) VALUES (@inputString)
    RETURN
END

SELECT splitValue
FROM dbo.SplitString(column_name, ',')