A single update or insert to a database table is often part of several other updates, deletes, or inserts (DML statements) within a unit of work for a particular task. Those inserts, updates, or deletes that must all succeed to maintain the integrity of the data must occur as a database transaction. Every modern RDBMS supports the concept of transactions by encapsulating one or more DML statements and treating them as an atomic unit of work.
KeywordsIntegrity Constraint Select Statement Update Statement Managing Transaction Recipe Solution
Unable to display preview. Download preview PDF.