Reading Time: 13 minutes As a database professional, you will be asked to come up with SELECT statements to pull needed information in a meaningful and accurate way. Sometimes you will need to review other SELECT statements written by other people, too. Maybe those queries have a problem which is causing it to pull Continue Reading
Set Operators
UNION and UNION ALL: What’s the difference?
Reading Time: 4 minutes Have you been working with SQL Server for a while, but aren’t really sure what the difference is between UNION and UNION ALL? When I was first learning T-SQL, I wondered this myself. I eventually figured it out, and I was glad to see the difference is very easy to Continue Reading
Set Operators in SQL Server: The Ultimate Guide for Beginners
Reading Time: 9 minutes SQL Server Set Operators are one of the more common tools we have available to us when querying SQL Server databases. It is important you know how to write them and how they work. Set operators are part of the Top 6 tools you should know for writing AWESOME Select Continue Reading
Set Operator Precedence: Explained
Reading Time: 7 minutes In this tutorial, we will discuss a very useful topic you should know when querying SQL Server databases: Set Operator precedence. The three set operators available to us in SQL Server are UNION, INTERSECT, and EXCEPT. I have in-depth tutorials on all 3 different set operators, found there: The UNION Continue Reading
SQL Server EXCEPT: Everything You Need to Know
Reading Time: 10 minutes In this tutorial, we’re going to learn about a very common Set Operator you should know: The EXCEPT Set Operator. Set operators are one of the more common tools we have available to us when querying SQL Server databases. It is important you know how to write them, and how Continue Reading
SQL Server INTERSECT: Everything you need to know
Reading Time: 8 minutes Set operators are one of the more common tools we have available to us when querying SQL Server databases. It is important you know how to write them, and how they work. The INTERSECT Set Operator, of course, is one of those operators you need to know. You should also Continue Reading
SQL Server UNION: Everything you need to know
Reading Time: 11 minutes In this tutorial, we will discuss one of the more common operators available to us when querying SQL Server databases: The UNION set operator. We will also discuss it’s older sister: The UNION ALL set operator. This tutorial will be the first of three on the topic of SQL Server Continue Reading