Comparing values across many columns is a common chore. Here is how the MySQL LEAST and GREATEST comparison operators find the smallest and largest value.
SQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2
Five expressions flip a bit value in SQL Server without a CASE statement. This post runs Vinod Kumar’s four methods and the readers’ answers on SQL Server 2025, shows what each one returns for 0, 1 and NULL, and explains how to flip value of bit field data stored in an integer column.
AND Before OR: Operator Precedence in WHERE Clauses
A report showed closed orders even though the filter said open. The reason is how SQL Server groups AND and OR.
Finding Rows That Differ Between Two Tables With EXCEPT
Use EXCEPT to find differing rows in both directions, compare selected columns, handle NULLs, and distinguish changed keys from additions.
SELECT 7 & 7 or 7 ^ 7: Bitwise XOR, AND and OR on Integers
Understand bitwise XOR, AND and OR in T-SQL, test and change integer flags, explain two sevens, and compare the newer bit functions.
Set Operator Rules: Column Names, Types and ORDER BY With UNION
Why did my UNION change its headers, fail on a word, or sort wrong? Small examples show each rule and the error it produces.
IS DISTINCT FROM in SQL Server 2022: NULL-Safe Comparisons
Use IS DISTINCT FROM for NULL-safe comparisons in SQL Server 2022, understand older workarounds, and inspect index seeks before changing code.