I’m commonly asked whether whether I can have a CASE Statement in the WHERE Clause. There are a number of
In this article we learn the difference between a primary and unique key, and why both are important to maintaining
Both inner and outer joins are used to combine data from two or more tables; however, there are some key
Both Joins and UNIONS can be used to combine data from two or more tables. Read this article to find
Both TOP and OFFSET & FETCH can be used to limit the number of rows returned. OFFSET and FETCH can
This article is inspired by a series of questions that one of my readers, Nan, recently sent me regarding DISTINCT,
A reader recently asked me to help them solve a problem combining data from multiple tables into a single result.
Are you serious about learning SQL? If so, then get started with free tools using my Guide Getting Started Using SQL Server.
What is a Database Trigger? A database trigger is special stored procedure that is run when specific actions occur within
In SQL Server there are a couple a ways you can delete rows from a table. You can use the TRUNCATE
Sort Alphanumeric Values with SQL Server Recently a reader asked me how to sort an alpha numeric field in SQL
What is a Null Value? In databases a common issue is what value or placeholder do you use to represent