There are four main categories of statements used when writing T-SQL. What are the differences between each of these categories?
What is the data manipulation language (DML)? How to write the INSERT, UPDATE, and DELETE statements in T-SQL.
What is the difference between the DELETE, TRUNCATE, and DROP statements in T-SQL?
How to use the output clause with Data Manipulation Language (DML) statements like INSERT, UPDATE, and DELETE.