Microsoft.Press.Training.Kit.Exam.70-461.Nov.2012

Chapter 11Other Data ModificationAspectsExam objectives in this chapter: ■■ Modify Data ■■ Modify data by using INSERT, UPDATE, and DELETE statements. ■■ Combine datasets.Chapter 10, “Inserting, Updating, and Deleting Data,” covered the three fundamental data modification statements: INSERT, UPDATE, and DELETE. This chapter covers ad-ditional aspects of data modification such as the sequence object and the IDENTITY columnproperty, the MERGE statement, and the OUTPUT option.Lessons in this chapter: ■■ Lesson 1: Using the Sequence Object and IDENTITY Column Property ■■ Lesson 2: Merging Data ■■ Lesson 3: Using the OUTPUT OptionBefore You BeginTo complete the lessons in this chapter, you must have: ■■ Experience working with Microsoft SQL Server Management Studio (SSMS). ■■ Some experience writing T-SQL code. ■■ An understanding of data types. ■■ An understanding of combining sets. ■■ An understanding of data modification statements. ■■ Access to a SQL Server 2012 instance with the sample database TSQL2012 installed. 369