Chapter 12. Modifying data
After completing this chapter, you will be able to
Insert data into SQL Server tables.
Update data in tables.
Delete data from tables.
Merge data.
Return output data.
So far in this book, you have worked with tables that contain data. In most cases, a client-based application will be the primary mechanism for inserting and modifying data in Microsoft SQL Server tables. However, a situation may arise in which you need to add or modify data inside your database tables. SQL Server offers several different ways of modifying data. In this chapter, you will learn how to perform simple inserts, updates, and deletes. You will also see how to merge data from two sources into one and return output data.
Inserting data into SQL Server ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
