Day 7. Adding, Changing, and Deleting Rows
In the past six days, you have seen how to retrieve data from the database by using the SELECT statement along with a variety of optional parameters. After this data is retrieved, you can use it in your application program or edit it. So far, the focus has been on retrieving the data. However, you might have wondered how to enter data into the database in the first place.
Today, you will learn several ways of manipulating the data within the database. These topics include
Creating tables
Inserting rows
Updating rows
Deleting rows
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition 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.
