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…
What is SQL? What is the difference between SQL the language and SQL the server?
There are four main categories of statements used when writing T-SQL. What are the differences between each of these categories?
The four-part names of SQL Server objects. How to reference objects in SQL Server by their four-part name and how to use it in a T-SQL statement.
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.
How to use the WHERE statement to filter records when the value is either a Date or a Time in a T-SQL statement.
How to use the WHERE statement to filter records when a value IS NULL or IS NOT NULL in a T-SQL statement.