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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.