3 replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/ edited Apr 13 '17 at 12:42 You can use this approach from Paul WhitePaul White's article Undocumented Query Plans: Equality Comparisons ``````SELECT * FROM A INNER JOIN B ON A.ID = B.ID AND EXISTS(SELECT A.* EXCEPT SELECT B.*) `````` You can use this approach from Paul White's article Undocumented Query Plans: Equality Comparisons ``````SELECT * FROM A INNER JOIN B ON A.ID = B.ID AND EXISTS(SELECT A.* EXCEPT SELECT B.*) `````` You can use this approach from Paul White's article Undocumented Query Plans: Equality Comparisons ``````SELECT * FROM A INNER JOIN B ON A.ID = B.ID AND EXISTS(SELECT A.* EXCEPT SELECT B.*) `````` 2 Expanded credit edited Jul 4 '16 at 19:24 Martin Smith 71.3k1010 gold badges187187 silver badges289289 bronze badges You can use this approach from Paul White's article You can useUndocumented Query Plans: Equality Comparisons ``````SELECT * FROM A INNER JOIN B ON A.ID = B.ID AND EXISTS(SELECT A.* EXCEPT SELECT B.*) `````` You can use ``````SELECT * FROM A INNER JOIN B ON A.ID = B.ID AND EXISTS(SELECT A.* EXCEPT SELECT B.*) `````` You can use this approach from Paul White's article Undocumented Query Plans: Equality Comparisons ``````SELECT * FROM A INNER JOIN B ON A.ID = B.ID AND EXISTS(SELECT A.* EXCEPT SELECT B.*) `````` 1 answered Mar 16 '12 at 20:14 Martin Smith 71.3k1010 gold badges187187 silver badges289289 bronze badges You can use ``````SELECT * FROM A INNER JOIN B ON A.ID = B.ID AND EXISTS(SELECT A.* EXCEPT SELECT B.*) ``````