Udostępnij za pośrednictwem


Change Data Capture Functions (Transact-SQL)

Change data capture records insert, update, and delete activity applied to SQL Server tables, supplying the details of the changes in an easily consumed relational format. Column information that mirrors the column structure of a tracked source table is captured for the modified rows, along with the metadata needed to apply the changes to a target environment. The following functions are used to return information about the changes.

cdc.fn_cdc_get_all_changes_<capture_instance> (Transact-SQL)

sys.fn_cdc_has_column_changed (Transact-SQL)

cdc.fn_cdc_get_net_changes_<capture_instance> (Transact-SQL)

sys.fn_cdc_increment_lsn (Transact-SQL)

sys.fn_cdc_decrement_lsn (Transact-SQL)

sys.fn_cdc_is_bit_set (Transact-SQL)

sys.fn_cdc_get_column_ordinal (Transact-SQL)

sys.fn_cdc_map_lsn_to_time (Transact-SQL)

sys.fn_cdc_get_max_lsn (Transact-SQL)

sys.fn_cdc_map_time_to_lsn (Transact-SQL)

sys.fn_cdc_get_min_lsn (Transact-SQL)

 

Zobacz także

Odwołanie

Change Data Capture Stored Procedures (Transact-SQL)

Koncepcje

About Change Data Capture (SQL Server)

Inne zasoby

Change Data Capture Tables (Transact-SQL)