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) |
|
cdc.fn_cdc_get_net_changes_<capture_instance> (Transact-SQL) |
|
|
Zobacz także
Odwołanie
Change Data Capture Stored Procedures (Transact-SQL)
Koncepcje
About Change Data Capture (SQL Server)