SQL Server NULL Introduction
The value NULL in SQL Server cannot be fully discussed in only one post. So let’s start at […]
Blog
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 Course at Udemy Philip Burton
If you like watching videos to learn topics, consider Udemy.com This post is about a series of videos […]
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 […]
WordPress 4.8 Update
WordPress version 4.8 is out! Before upgrading, be sure to back up your site. I use UpDraftPlus. Here […]
SQL Server Check Constraints Part 3
Constraints and NULLs This is a continuation of our series on check constraints. We are going to consider […]
SQL Server Check Constraints Part 2
In this post we will look at some examples of check constraints in SQL Server. We will start […]
SQL Server Check Constraints Introduction
In SQL Server you will find that you need to keep control of the data that gets entered […]