Chapter 4. Data Modification with SQL Server Transact-SQL Statements
In the previous chapter, you learned how to query data stored in the SQL Server database tables. In this chapter, you will learn how to insert, update, and delete data in tables using Transact-SQL Data Manipulation Language (DML) statements. You will also learn how you can use Transact-SQL MERGE statements to perform multiple DML operations against a specified target table based on the results of join conditions with a source table. In the final section of this chapter, you will use Transact-SQL TRUNCATE TABLE statements to remove all data from a table, and use Transact-SQL SELECT INTO statements to create a table and (optionally) populate it with rows from a query.
In this chapter, ...
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.
