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?
This demonstration will walk through how to create table relationships and foreign key constraints using SQL.
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.
Learn how to use IDENTITY Columns to automatically number records in your database tables for efficient data management.
How to use the output clause with Data Manipulation Language (DML) statements like INSERT, UPDATE, and DELETE.