O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required