Abstract
In Chapter 10, you learned how to manipulate data using T-SQL statements. In this chapter, you will learn about a very important aspect of manipulating data: transactions. A transaction is a unit of work in SQL Server. Most of the time, a transaction is one statement that inserts, updates, or deletes data. It is possible, however, to define an explicit transaction that includes one or more statements. You can also include SELECT statements in a transaction. A transaction can be committed or rolled back as a unit.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Kathi Kellenberger
About this chapter
Cite this chapter
Kellenberger, K., Shaw, S. (2014). Managing Transactions. In: Beginning T-SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0046-9_13
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0046-9_13
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0047-6
Online ISBN: 978-1-4842-0046-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books