Data Modification Archives

Use Data Modification statements to change data in your database tables.

The database modification statements you’ll use the most are:


You can also combine these into one operation called MERGE!

I would recommend stating out by reading the article Learn how to Add, Remove, or Modify values in a SQL Table.

Then once you have gotten the basics, dig into more detailed articles on INSERT, UPDATE, and DELETE.

Don’t forget about MERGE!  I would highly recommend reading  Introduction to the Merge Statement once you have master the rest.

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.  You can get started using these free tools using my guide Getting Started Using SQL Server

Learn how to Add, Remove, or Modify values in a SQL Table


In this article we’ll discover data modification statements used to modify data in SQL server using the INSERT, UPDATE, DELETE, and MERGE statement. The SELECT, INSERT, UPDATE, DELETE, and MERGE statement are collectively referred to DML (Data Manipulation Language) statements.  These statements allow you to view and modify data.  We extensively cover SELECT in other […]

Continue reading