WITH CHANGE_TRACKING_CONTEXT (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
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.
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.
WITH CHANGE_TRACKING_CONTEXT ( context )
See Also
Change Tracking Functions (Transact-SQL)
CHANGETABLE (Transact-SQL)
Track Data Changes (SQL Server)
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre