Chapter 10. Data Modification

This chapter covers different facets of data modification. I’ll discuss aspects of inserting, deleting, updating, and merging data, as well as the OUTPUT clause for data modification statements. I’ll also cover new features related to data modification in Microsoft SQL Server 2008, which include an enhanced VALUES clause, minimally logged inserts, the MERGE statement, and a new feature I call composable DML.

Get Inside Microsoft® SQL Server® 2008: T-SQL Querying 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.