如何在SQL Server中的每个拆分项上获取带引号的拆分字符串？

DECLARE @splitString VARCHAR(100) = 'A,B,C,D'
DECLARE @delimiter CHAR(1) = ','

-- 将字符串拆分为多个项
DECLARE @splitTable TABLE (Item VARCHAR(100))
DECLARE @start INT, @end INT

SET @start = 1
SET @end = CHARINDEX(@delimiter, @splitString)

WHILE @end > 0
BEGIN
    INSERT INTO @splitTable (Item)
    VALUES (SUBSTRING(@splitString, @start, @end - @start))

    SET @start = @end + 1
    SET @end = CHARINDEX(@delimiter, @splitString, @start)
END

INSERT INTO @splitTable (Item)
VALUES (SUBSTRING(@splitString, @start, LEN(@splitString) - @start + 1))

-- 获取带引号的拆分字符串
SELECT QUOTENAME(Item, '''') AS QuotedItem
FROM @splitTable