Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours

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