log inhelp

 | 

  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Topic - Managing Transactions

Page history last edited by Dr. Ron Eaglin 11 years, 1 month ago

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

 

Assignments

 

COP4709 Spring 2013 Assignments - Week 5 assignment.

 

Comments (0)

You don't have permission to comment on this page.

Printable version