是否将SQL Server表中的数据复制到历史表中，并添加复制时间的时间戳？

CREATE TRIGGER CopyDataToHistory
ON SourceTable
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
    -- 复制插入的数据到历史表
    INSERT INTO HistoryTable (Column1, Column2, Timestamp)
    SELECT Column1, Column2, GETDATE()
    FROM inserted;

    -- 复制更新的数据到历史表
    INSERT INTO HistoryTable (Column1, Column2, Timestamp)
    SELECT Column1, Column2, GETDATE()
    FROM deleted;

    -- 复制删除的数据到历史表
    INSERT INTO HistoryTable (Column1, Column2, Timestamp)
    SELECT Column1, Column2, GETDATE()
    FROM deleted;
END