Post reply

Update the column changes

  • January 19, 2017 at 3:45 pm

    #317568

    Hi,

    i have 2 tables
    1 is Orininal table e structure
    2nd copy table with same structure

    daily 2nd tables copies with new data.

    how to  get the table data what are columns are updated daily,

    can any one please help us

  • January 19, 2017 at 11:59 pm

    #1923931

    Sree Divya - Thursday, January 19, 2017 3:45 PM

    Hi,

    i have 2 tables
    1 is Orininal table e structure
    2nd copy table with same structure

    daily 2nd tables copies with new data.

    how to  get the table data what are columns are updated daily,

    can any one please help us

    Create trigger on first table for Update,delete and insert. In trigger, On updated, deleted and inserted do the same in 2nd table.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply