Transactions Locks «Prev  Next»

Creating Transactions - Exercise

Objective: Practice creating a transaction.

Exercise Scoring

This exercise is worth a total of 5 points. You will receive up to 5 points for accurately creating the transaction described in the instructions.


Wrap any two Transact-SQL statements of your choosing within a transaction. Make sure to rollback the transaction if there are any errors after the first and second Transact-SQL statements.

Submitting the Exercise

Type or paste your statements into the text box below, then click Submit and view a results page.