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.
How to use an INSERT statement to add records to a table in SQL Server. We will begin with just a simple INSERT statement that will add one row into the table.
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.
How to use IDENTITY columns in a table. An IDENTITY field is very similar to an auto-number field, where the number will automatically be added as each record is inserted.