Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

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:

• Lesson 1: Inserting Data

• Lesson 2: Updating Data

• Lesson 3: Deleting Data

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