insert into history table

Question

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