Question

name two statements that can be used to end a transaction??​

Answer 1

Answer:

First, query the latest sales order number from the orders table and use the next sales order number as the new sales order number.

Next, insert a new sales order into the orders table.

Then, get the newly inserted sales order number

After that, insert the new sales order items into the orderdetails table with the sales order number

Finally, select data from both orders and orderdetails tables to confirm the changes