Chapter 10. Data Manipulation
After completing this chapter, you will be able to
Issue INSERT, UPDATE, DELETE, and MERGE commands
Manage transactions
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.
Inserting Data
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. ...
Get Microsoft® SQL Server® 2008 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
