This topic has not yet been rated - Rate this topic

WITH CHANGE_TRACKING_CONTEXT (Transact-SQL)

SQL Server 2012

Enables the context of a change to be specified, such as an originator ID, when data is changed. For example, when using change tracking, an application might want to differentiate between changes that were made by the application itself and changes that were made to the data outside the application.

Topic link icon Transact-SQL Syntax Conventions

Syntax


          

WITH CHANGE_TRACKING_CONTEXT ( context )

Parameters

context

Is the contextual information that is supplied by the calling application and stored with the change tracking information for the change. context is varbinary(128).

The value can be a constant or a variable, but cannot be NULL.

Examples

The following example sets the change tracking context for a data change.

Transact-SQL

-- The tracked change is tagged with the specified context 
DECLARE @originator_id varbinary(128);
SET @originator_id = CAST('MyApplicationID' AS varbinary(128));
WITH CHANGE_TRACKING_CONTEXT (@originator_id)
    UPDATE Employees
      SET Salary = 50000
      WHERE EmpID = 1 
-- The change now has an associated change context
SELECT c.EmpID, c.SYS_CHANGE_CONTEXT 
FROM CHANGETABLE(CHANGES Employees, @last_sync_version) AS c;

Reference

CHANGETABLE (Transact-SQL)

Concepts

Change Tracking Functions (Transact-SQL)

Track Data Changes

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD