O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

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

HOUR 8. Modifying Data with Action Queries

Not only can you use T-SQL to select data, you can also use it to update data. T-SQL enables you to update, insert into, and delete data from tables. In this hour you’ll learn:

How to use the UPDATE statement to update table data

How to use the INSERT statement to insert data into an existing table

How to use the SELECT INTO statement to insert data into a new table

How to use the DELETE statement to selectively delete data from a table

How to use the TRUNCATE statement to remove all data from a table

By the Way

The examples that follow are based on a database called Northwind which is included on the sample code CD. Instructions as to how to install the Northwind database are included in ...

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