SQL Server 2014 Development Essentials

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.