SQL transaction rollback and commit : <p>I have the below 3 inserts wrapped in a transaction. If any of the inserts fail for any reason I would like the entire transaction rolled back. and if all 3 are successful I would like it commited.</p>

<pre><code>BEGIN TRANSACTION

    INSERT INTO myTable (myColumns ...) VALUES (myValues ...);
    INSERT INTO myTable (myColumns ...) VALUES (myValues ...);
    INSERT INTO myTable (myColumns ...) VALUES (myValues ...);

COMMIT TRAN 
</code></pre>
