Neol, thanks for the brilliant answer!

The BINARY_CHECKSUM(*) function was exactly what I needed! Let's hope it uses a good hash function so I will never miss any changed rows...

BINARY_CHECKSUM(t1.ColX)<>BINARY_CHECKSUM(t2.ColX)

also seems...