Exam objectives in this chapter
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:
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 ...