Chapter 10. Inserting, Updating, and Deleting Data

Exam objectives in this chapter

  • Modify Data

    • Modify data by using INSERT, UPDATE, and DELETE statements.

This chapter covers certain aspects of data modification. It describes how to insert, update, and delete data by using different T-SQL statements. Chapter 11, continues the topic by covering more specialized aspects of data modification.

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 T-SQL code.

  • Access to a SQL Server 2012 instance with the sample database TSQL2012 installed.

  • An understanding ...

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.