How can I use one INSERT statement and an INSERT trigger to add records to two tables at the same time?

To add records to two tables at the same time, you need to direct your INSERT statement at the first table. Then, on that table, create an INSERT trigger that uses the inserted table to add records to the second table. Listing 3 shows sample code that performs these operations.

The mo...