Murach's SQL Server 2005 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.
Chapter 7 How to insert, update, and delete data
How to create test tables 198
How to use the SELECT INTO statement 198
How to use a copy of the database 198
How to insert new rows 200
How to insert a single row 200
How to insert default values and null values 202
How to insert rows selected from another table 204
How to modify existing rows 206
How to perform a basic update operation 206
How to use subqueries in an update operation 208
How to use joins in an update operation 210
How to delete existing rows 212
How to perform a basic delete operation 212
How to use subqueries and joins in a delete operation 214
Perspective 216
t


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

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



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.