In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…
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.