Chapter 11. Other Data Modification Aspects

Exam objectives in this chapter:

  • Modify Data

    • Modify data by using INSERT, UPDATE, and DELETE statements (use output clause).

    • Combining datasets.

Chapter 10, covered the three fundamental data modification statements: INSERT, UPDATE, and DELETE. This chapter covers additional aspects of data modification such as the sequence object and the IDENTITY column property, the MERGE statement, and the OUTPUT option.

Lessons in this chapter:

Before You Begin

To complete the lessons in this chapter, you must have:

  • Experience working with Microsoft SQL Server Management Studio (SSMS).

  • Some experience writing ...

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 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.