Hello,
I have a small query:
I have a primary table & i want to create a backup of that primary table in such a way that whenever a new record gets added to the primary, it should automatically add in the backup table & along with that if i delete any row in the primary table, the corresponding row should not get deleted from the backup table.
I need old records also in my backup table even though if i delete couple of rows in primary table.
Any help would be appreciated.
Thanks in advance.