Table Comparision

SELECT Label='Found IN Table1, NOT IN Table2',* FROM
(SELECT * FROM Table1
 EXCEPT
 SELECT  * FROM Table2) x
UNION ALL
SELECT Label='Found IN Table2, NOT IN Table1',* FROM
(SELECT  * FROM Table2
 EXCEPT
 SELECT * FROM Table1) y

GO

-- SQL find rows present in both tables
SELECT * FROM AdventureWorks2008.Production.Product
INTERSECT
SELECT * FROM AdventureWorks.Production.Product

SELECT * FROM Product1 p1
WHERE NOT EXISTS (SELECT * FROM Product2  p2
                  WHERE p2.ProductId = p1.ProductId)
GO

SELECT * FROM Product1  p1
  LEFT OUTER JOIN Product2  p2
    ON p2.ProductId = p1.ProductId
WHERE p2.ProductId IS NULL
GO