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