sys.fn_cdc_decrement_lsn

change-data-capture

#change-data-capture#function

Description

Syntax

sys.fn_cdc_decrement_lsn ( lsn_value )

Examples

Example 1

sys.fn_cdc_decrement_lsn ( lsn_value )

Example 2

sys.fn_cdc_decrement_lsn

Example 3

Use
AdventureWorks2022;
GO
DECLARE
@from_lsn binary (10), @to_lsn binary (10);
SET
@from_lsn = sys.fn_cdc_get_min_lsn(
'HumanResources_Employee'
);
SET
@to_lsn = sys.fn_cdc_decrement_lsn(sys.fn_cdc_get_max_lsn());
SELECT
*
FROM cdc.fn_cdc_get_all_changes_HumanResources_Employee( @from_lsn,
@to_lsn,
'all'
);
GO

Example 4

cdc.fn_cdc_get_all_changes_<capture_instance>

Example 5

cdc.fn_cdc_get_net_changes_<capture_instance>

Example 6

lsn_value

Example 7

Msg 313, Level 16, State 3, Line 1 An insufficient number of arguments were supplied for the procedure or function