问SQL Server:显示两行之间在列中的差异

EN

-- setting up test-data
IF OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test

SELECT ID     = 360111,
       GName  = 'Billy',         
       SName  = 'Bob',       
       Add1   = '1 Happy St',   
       Add2   = 'Sydney'
 INTO #test

UNION ALL 

SELECT ID     = 360111,
       GName  = 'Billy',     
       SName  = 'Bob',      
       Add1   = '6 Sunny St',   
       Add2   = 'Melbourne'


GO
-- find different columns and list them
DECLARE @c_column_name sysname
DECLARE @sql nvarchar(max)

IF OBJECT_ID('tempdb..#diff_columns') IS NOT NULL DROP TABLE #diff_columns

SELECT column_name = name
  INTO #diff_columns 
  FROM sys.columns
 WHERE 1 = 2

DECLARE column_loop CURSOR LOCAL FAST_FORWARD
    FOR SELECT diff_columns = name
          FROM tempdb.sys.columns
         WHERE object_id = object_id('tempdb..#test')
           AND name <> 'ID' -- no need to test the key-field
OPEN column_loop
FETCH NEXT FROM column_loop INTO @c_column_name
WHILE @@FETCH_STATUS = 0
    BEGIN
        SELECT @sql = 'INSERT #diff_columns (column_name)
                       SELECT ''' + @c_column_name + '''
                        WHERE EXISTS ( SELECT * FROM #test HAVING COUNT (DISTINCT ' + @c_column_name + ') > 1)'

        EXEC (@sql)                        

        FETCH NEXT FROM column_loop INTO @c_column_name
    END
CLOSE column_loop 
DEALLOCATE column_loop 

SELECT @sql = 'SELECT ID'
SELECT @sql = @sql + ', ' + column_name
  FROM #diff_columns
SELECT @sql = @sql + ' FROM #test'

EXEC (@sql)