如何在sql触发器中拆分字符串和获取数据

CREATE TRIGGER [dbo].[SplitStringTrigger]
ON [dbo].[YourTable]
AFTER INSERT
AS
BEGIN
    -- 获取插入的数据
    DECLARE @InsertedData TABLE (ID INT, StringValue VARCHAR(MAX))
    INSERT INTO @InsertedData (ID, StringValue)
    SELECT ID, StringValue FROM inserted

    -- 拆分字符串并获取数据
    DECLARE @SplitData TABLE (ID INT, Value VARCHAR(MAX))
    INSERT INTO @SplitData (ID, Value)
    SELECT ID, SUBSTRING(StringValue, Number + 1, CHARINDEX(',', StringValue, Number + 1) - Number - 1)
    FROM @InsertedData
    CROSS APPLY (
        SELECT Number
        FROM master.dbo.spt_values
        WHERE type = 'P'
        AND Number <= LEN(StringValue) - LEN(REPLACE(StringValue, ',', ''))
    ) AS Numbers

    -- 在此处进行后续的操作，例如将拆分后的值插入到其他表中
    -- INSERT INTO OtherTable (ID, Value) SELECT ID, Value FROM @SplitData
END