Lesson 10. 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 gives you the ability to update, insert into, and delete data from tables. In this lesson, you learn:

Image How to use the UPDATE statement to update table data

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

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

How to use the DELETE

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.