jayu p

jayu p

  • 2k
  • 88
  • 2.6k

insert into history table

Feb 3 2022 2:48 PM

Hi,

I have two tables

  • Table-A must contains current data rows.
  • Table-A-History must contains historical data

whenever a new data row is available, update Table-A's row and insert a new row into Table-A-History.

This needs to be achieve without using trigger on table,

but may be with help of stored proc

Could anyone of you can help here


Answers (9)