Chapter 10. Data Manipulation
After completing this chapter, you will be able to
Issue INSERT, UPDATE, DELETE, and MERGE commands
Configure and utilize change tracking
In this chapter, you will learn how to add, modify, and remove rows from a table. You will also learn how to create a new table and insert data in a single operation. Core to the ability to manipulate data is the ability to manage transactions and locking within a database. Finally, you will learn about the new change data tracking features of SQL Server 2008.
SQL Server provides several ways to add and insert data into a table. In this section, you will learn how to construct a basic INSERT statement that specifies the data to be inserted into a table. ...