What is the correct SQL for a trigger to copy a record to an identical table?
- by Owen
I have two tables TABLE1 and TABLE2 with identical structures. I need a trigger to copy a record after insert from TABLE1 to TABLE2. What's the proper SQL for this?