Murach's SQL Server 2008 for Developers
How to insert, update, and delete data

This chapter teaches you how to code action queries to modify the data in a table using the SQL INSERT, UPDATE, and DELETE statements. It also introduces you to the 2008 MERGE statement, which allows you to make multiple updates and insertions with a single statement.
Chapter 7 How to insert, update, and delete data
How to create test tables 212
How to use the SELECT INTO statement 212
How to use a copy of the database 212
How to insert new rows 214
How to insert a single row 214
How to insert multiple rows 214
How to insert default values and null values 216
How to insert rows selected from another table 218
How to modify existing rows 220
How to perform a basic update operation 220
How to use subqueries in an update operation 222
How to use joins in an update operation 224
How to delete existing rows 226
How to perform a basic delete operation 226
How to use subqueries and joins in a delete operation 228
How to merge rows 230
How to perform a basic merge operation 230
How to code more complex merge operations 230
t


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.