Congratulations!

Transactions and Error Handling in SQL Server

Miriam Antona

Software Engineer

Chapters 1 and 2 - Error handling

• TRY...CATCH construct
• Error anatomy
• Uncatchable errors by a CATCH block
• Error functions: ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), ERROR_LINE(), ERROR_PROCEDURE(), ERROR_MESSAGE()
• RAISERROR
• THROW

Chapter 3 - Transactions

• What is a transaction?
• Transaction statements:
  • BEGIN TRAN
  • COMMIT TRAN
  • ROLLBACK TRAN
• @@TRANCOUNT
• Savepoints
• XACT_ABORT
• XACT_STATE

Chapter 4 - transaction isolation levels

• What is concurrency?
• Isolation levels:
  • READ UNCOMMITTED
  • READ COMMITTED
  • REPEATABLE READ
  • SERIALIZABLE
  • SNAPSHOT
• Concurrency phenomena: dirty reads, non-repeatable reads, phantom reads

Thank you!

Transactions and Error Handling in SQL Server