如何在SQL Server表中插入逗号分隔的字符串

CREATE TABLE YourTable (
    ID INT IDENTITY(1,1) PRIMARY KEY,
    CommaSeparatedString VARCHAR(MAX)
);

INSERT INTO YourTable (CommaSeparatedString)
VALUES ('value1,value2,value3');

-- 使用循环插入多个逗号分隔的字符串
DECLARE @Strings VARCHAR(MAX) = 'value1,value2,value3,value4';
DECLARE @Delimiter CHAR(1) = ',';
DECLARE @Pos INT;
DECLARE @Value VARCHAR(MAX);

WHILE CHARINDEX(@Delimiter, @Strings) > 0
BEGIN
    SELECT @Pos = CHARINDEX(@Delimiter, @Strings);
    SELECT @Value = SUBSTRING(@Strings, 1, @Pos - 1);

    INSERT INTO YourTable (CommaSeparatedString)
    VALUES (@Value);

    SELECT @Strings = SUBSTRING(@Strings, @Pos + 1, LEN(@Strings));
END

-- 使用批量插入多个逗号分隔的字符串
DECLARE @Strings VARCHAR(MAX) = 'value1,value2,value3,value4';
DECLARE @Delimiter CHAR(1) = ',';
DECLARE @Values TABLE (Value VARCHAR(MAX));

INSERT INTO @Values (Value)
SELECT value
FROM STRING_SPLIT(@Strings, @Delimiter);

INSERT INTO YourTable (CommaSeparatedString)
SELECT Value
FROM @Values;