将表中所有字段的日志更改记录到另一个表(SQL Server )

ALTER DATABASE your_database_name
SET CHANGE_TRACKING = ON
(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)

ALTER TABLE your_table_name
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON)

CREATE TABLE your_table_name_changes (
    change_id BIGINT IDENTITY(1,1) NOT NULL,
    change_time DATETIME NOT NULL,
    change_type NVARCHAR(10) NOT NULL,
    primary_key_column_name your_primary_key_column_type NOT NULL,
    ...
    PRIMARY KEY (change_id)
)

CREATE PROCEDURE your_table_name_changes_proc
AS
BEGIN
    DECLARE @last_sync_version BIGINT
    SET @last_sync_version = (SELECT MAX(change_id) FROM your_table_name_changes)

    ;WITH changes AS (
        SELECT CT.*
        FROM CHANGETABLE(CHANGES your_table_name, @last_sync_version) AS CT
    )
    INSERT INTO your_table_name_changes (change_time, change_type, primary_key_column_name, ...)
    SELECT change_time, change_type, primary_key_column_name, ...
    FROM changes
END

EXEC your_table_name_changes_proc