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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.