Bài giảng Hệ quản trị cơ sở dữ liệu SQL Server - Lecture 11: How to manage transactions and locking - Lê Thị Tú Kiên

Objectives Applied

• Given a set of statements to be combined into a transaction, insert

the Transact-SQL statements to explicitly begin, commit, and roll back the transaction.

Knowledge

• Describe the use of implicit transactions.

• Describe the use of explicit transactions.

Describe the use of the COMMIT TRAN statement and the

@@TRANCOUNT function within nested transactions.

 • Describe the use of save points.

• Define these types of concurrency problems: lost updates, dirty

reads, nonrepeatable reads, and phantom reads.