Summary

This chapter covered data modification within SQL Server. You modify most data using the three SQL DML statements: INSERT, UPDATE, and DELETE. Although you can typically think of INSERT as affecting only one row, SQL Server provides several forms of INSERT that can insert an entire result set at once. In addition, SQL Server offers utilities and interfaces for fast bulk loading of data. UPDATE and DELETE operations can include search operations to find the rows to modify, bringing to bear all the power of the SQL query language to specify the rows.