比较两个记录集是否相等

IF  (
        SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*))
        FROM   (
                    -- first resultset to compare
                    SELECT  *
                    FROM    Person.Address
               ) t1
    )
    =        
    (
        SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*))
        FROM   (
                    -- second resultset to compare
                    SELECT  *
                    FROM    Person.Address
                    WHERE   AddressID < 1000 
               ) t1
    )
    BEGIN
        SELECT 'Resultsets equal'
    END
ELSE
    BEGIN
        SELECT 'Resultsets NOT equal' 
    END