Summary
The SQL Server Transact-SQL language has a set of DML statements that you can use to manipulate table data. In this chapter, you learned how to add data to a table using the INSERT
statement, how to delete the data using the DELETE
statement, and how to update existing data using the UPDATE
statement. You learned about the MERGE
statement and how you can use it to avoid multiple INSERT
, UPDATE
, and DELETE
DML statements. You also learned how to use the TRUNCATE TABLE
and SELECT…INTO
statements.
Get SQL Server 2014 Development Essentials 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.