An underrated operator: using EXCEPT in MS SQL Server to track changes

Working with a colleague who is a longtime Oracle user, I noticed he used an operator I didn’t know of, to grab hold of the differences in rows between two nearly identical tables: he used a “minus”. I couldn’t imagine MS SQL Server would not have something like it and it didn’t, it came up with the “except” operator which does exactly the same.

The trick is that you use it like you are used to with  the union operator. Lees meer over dit bericht