Probably the logic is written in the diagram. Please show me how to solve the problem after EXECUTE. The transaction count indicates that the number of BEGIN and COMMIT statements does not match. This is the wrong report.
Careless, I forgot to add “commit tran” to the update statement and add the submission transaction. Pay more attention later.