Category Archives: Programming

In the previous post, I covered how to filter the results of a SELECT statement using the WHERE clause. Now I will go over one of the most basic ways that you can use T-SQL to derive information from a data set – aggregate functions and the GROUP BY clause. The Northwind sample database willContinue reading “T-SQL Fundamentals 3 – Aggregate Functions and the GROUP BY Clause”

In the previous post, I introduced the SELECT statement and demonstrated how to use it to pull data from the database. Now that we are comfortable with the basic usage, let’s build on our knowledge by adding a WHERE clause. If you are unfamiliar with boolean algebra, it is strongly recommended that you read thisContinue reading “T-SQL Fundamentals 2 – The WHERE Clause”

In the previous post, we installed SSMS and discussed some of the things that SQL can do. Let’s jump straight into writing our first query. Right-click on the Northwind database in the Object Explorer and click on New Query. This will open a blank query window for you to type your code into. The SELECTContinue reading “T-SQL Fundamentals 1 – The Select Statement”