Topic – Managing Transactions
The real used of stored procedures is their ability to encapsulate transactions (this can be done without transactions – but they are much easier to maintain as stored procedures). You will review the basic concepts of transactions (the ACID test) and create a transaction.
Reading
Required – Wikipedia on Transactions http://en.wikipedia.org/wiki/Database_transaction
Required – Wikipedia on ACID http://en.wikipedia.org/wiki/ACID
Lectures
Lecture – Getting Started with Transactions in T-SQL