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, we'll cover the following topics:
Inserting data into SQL Server database tables
Updating data in SQL Server database tables
Deleting data from SQL Server database tables
Using Transact-SQL
MERGE
statements to perform multiple DML operations using...