Modify data with T-SQL
Learn how to use Transact-SQL to insert, update, and delete data in a database.
Learning objectives
After completing this module, you will be able to:
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
Prerequisites
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve data from tables in a database.