database - How To Write SQL transaction for the Fallowing scenario

Question

Sale Table (ItemNo ,OrderDate,Quantitysold) Item Master Table (ItemNo,ItemName,QuantityInHand)

When A sale made new record Will be written To the Sale Table And the Quantity In Hand in the Item Master Table Has to be updated How To Write SQL transaction for the this scenario

question from:https://stackoverflow.com/questions/65901230/how-to-write-sql-transaction-for-the-fallowing-scenario

Answer 1

Waitting for answers