Getting all changed tables and rows using Change Tracking in SQL Server-CodePudding

Home > Software design > Getting all changed tables and rows using Change Tracking in SQL Server

Getting all changed tables and rows using Change Tracking in SQL Server

Time：06-15

The

In this triggers you access to manage many actions in your database like table changes, etc. An example of this triggers like this:

CREATE TRIGGER trigger1 ON DATABASE FOR DDL_TABLE_EVENTS AS DECLARE @data XML SET @data = EVENTDATA() BEGIN SELECT @data -- do what you whant with openxml SQL function END GO

@data is an XML that contains all of you need to understand from changes.

Page link：https//www.codepudding.com/Softwaredesign/442621.html

Prev:How to define conditions based on the length of the files with React.js?

Next:How does Elasticsearch query by text so fast?