CDC to find what column change

• Guras

  SSCertifiable

  Points: 6518

  More actions

  July 28, 2016 at 10:12 am

  #315608

  I have a CDC enabled on a table and every week I do incremental load to a static table Table1_CT_Incremetal . I have data worth of few months on this table. Now from this table I have to insert the data to a new History table that looks something like this

  changedColName BeforeVal AfterVal Transaction time

  How can I find what column value( name of the column updated) changed .

• shahm10

  SSCrazy

  Points: 2217

  More actions

  July 28, 2016 at 2:48 pm

  #1892548

  You can use __$update_mask column with sys.fn_cdc_is_bit_set CDC function to find columns which were updated for a particular record.