Reading Time: 9 minutesSQL 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 minutesIn 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 minutesIn 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