Now that you know what transactions processing is, let's look at what is involved in managing transactions.
Implementation Differences The exact syntax used to implement transaction processing differs from one DBMS to another. Refer to your DBMS documentation before proceeding.
The key to managing transactions involves breaking your SQL statements into logical chunks and explicitly stating when data should be rolled back and when it should not.
Some DBMSs require that you explicitly mark the start and end of transaction blocks. In SQL Server, for example, you can do the following:
BEGIN TRANSACTION … COMMIT TRANSACTION
In this example, any SQL between the BEGIN TRANSACTION and COMMIT TRANSACTION statements ...