change-data-capture-functions-transact-sql.md

title	Change Data Capture Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	change data capture [SQL Server], functions
ms.assetid	e5270557-aca3-44ab-8715-daccd498b88d
caps.latest.revision	8
author	rothja
ms.author	jroth
manager	craigg
ms.workload	On Demand

Change Data Capture Functions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Change data capture records insert, update, and delete activity applied to [!INCLUDEssNoVersion] 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)

See Also

Change Data Capture Tables (Transact-SQL)
Change Data Capture Stored Procedures (Transact-SQL)
About Change Data Capture (SQL Server)