Perform, Capture, and Track Data Modifications
Inserting multiple rows from a single INSERT statement. I’ll also demonstrate using the multiple-row technique to create a query data source in a SELECT clause (without having to create a permanent or temporary table).
New assignment operators that allow you to modify a passed data value with minimal coding.
The new MERGE command, which allows you to consolidate and apply data modification commands using a single block of code.
Storing unstructured data on the file system while maintaining SQL Server transactional control using the new FILESTREAM attribute.
Two new options for tracking table data changes using Change Data Capture (CDC) and Change Tracking built-in functionality. Before going into the new features, however, I’ll start the chapter off by reviewing basic INSERT concepts.
Unable to display preview. Download preview PDF.