SQL Server Summarizing Data Part 3
In the previous post we covered summarizing data using the following words: select, from, where, group by, having […]
SQL Server
SQL Server Summarizing Data Part 2
Criteria As we continue from our previous post, here is another example of summarizing data. We are continuing […]
SQL Server Summarizing Data Introduction
For a simple example on summarizing data, please have a look at Part 4 of this series. This […]
SQL Server Strings Concatenation
Numbers and Strings If you want to concatenate a number to a string you need to know how […]
SQL Server NULL Introduction
The value NULL in SQL Server cannot be fully discussed in only one post. So let’s start at […]
SQL Server String Types
There are only four types of strings. However, there are two that exist currently in SQL Server but […]
SQL Server Linked to Excel
You can link Excel to a SQL Server database so that you can read data from SQL Server […]
SQL Server Over() Partition By
Sum and Over This post will discuss the first two of three components of over(). The three components […]
SQL Server Sequential Numbers Part 3
This post continues from the previous post Part 2. In this post we are working with three tables. […]
SQL Server Sequential Numbers Part 2
This post is part 2 in our series of generating sequential numbers in SQL Server. In this post […]
SQL Server Sequential Numbers
A Simple Sequence We are going to first create a query that gives us sequence numbers in a […]
SQL Server Check Constraints Part 3
Constraints and NULLs This is a continuation of our series on check constraints. We are going to consider […]