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