Chapter 8 -- Modifying Data

Chapter 8

In Chapter 7, we looked at how to query data. In this chapter, we'll look at inserting, updating, and deleting data in tables. We'll see the basic SQL commands for these operations but focus on Microsoft SQL Server_specific behaviors. This chapter considers each statement as an independent, atomic operation. The ability to group multiple statements into an all-or-nothing atomic operation (that is, a transaction ) is presented in Chapter 10. Chapter 6 examined various types of constraints. Although using constraints is closely related to discussions about modifying data, this chapter's information and examples of modifying data assume that the modifications being performed satisfy any constraints on a table.