查找SQL Server中值更改的时间

CREATE TRIGGER track_value_changes
ON your_table
AFTER UPDATE
AS
BEGIN
    IF UPDATE(your_column)
    BEGIN
        INSERT INTO value_changes (column_name, old_value, new_value, change_time)
        SELECT 'your_column', d.your_column, i.your_column, GETDATE()
        FROM deleted d
        INNER JOIN inserted i ON d.primary_key = i.primary_key
    END
END

CREATE TABLE your_table
(
    your_column INT,
    valid_from DATETIME2 GENERATED ALWAYS AS ROW START HIDDEN,
    valid_to DATETIME2 GENERATED ALWAYS AS ROW END HIDDEN,
    PERIOD FOR SYSTEM_TIME (valid_from, valid_to)
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.your_table_history))

SELECT valid_from, valid_to
FROM your_table
FOR SYSTEM_TIME
    BETWEEN 'start_time' AND 'end_time'
WHERE your_column = 'value'