如何在SQL Server中通过拆分字符串插入数据

CREATE PROCEDURE SplitStringAndInsertData
    @inputString NVARCHAR(MAX),
    @delimiter NVARCHAR(1),
    @tableName NVARCHAR(MAX)
AS
BEGIN
    DECLARE @tempTable TABLE (Value NVARCHAR(MAX))

    WHILE CHARINDEX(@delimiter, @inputString) > 0
    BEGIN
        INSERT INTO @tempTable (Value)
        SELECT
            Value = LTRIM(RTRIM(SUBSTRING(@inputString, 1, CHARINDEX(@delimiter, @inputString) - 1)))

        SET @inputString = SUBSTRING(@inputString, CHARINDEX(@delimiter, @inputString) + 1, LEN(@inputString))
    END

    INSERT INTO @tempTable (Value)
    SELECT Value = LTRIM(RTRIM(@inputString))

    INSERT INTO YourTableName (ColumnName)
    SELECT Value
    FROM @tempTable
END

EXEC SplitStringAndInsertData 'Value1,Value2,Value3', ',', 'YourTableName'