可以使用动态SQL语句以及系统存储过程sys.columns来实现列名的查询。以下是一个例子：

CREATE PROCEDURE CompareTwoRows @table1 NVARCHAR(50), @table2 NVARCHAR(50), @id INT AS BEGIN DECLARE @sql NVARCHAR(MAX) = '' DECLARE @columns NVARCHAR(MAX) = ''

SELECT @columns += CASE
                        WHEN table1.value <> table2.value THEN
                            '[' + table1.name + '],'
                        ELSE
                            ''
                    END
FROM (
    SELECT c.name, CONVERT(NVARCHAR(MAX), t1.value) AS value
    FROM sys.columns c
    INNER JOIN @table1 t1 ON OBJECT_ID(@table1) = t1.object_id
    WHERE c.name NOT IN ('id')
) AS table1
INNER JOIN (
    SELECT c.name, CONVERT(NVARCHAR(MAX), t2.value) AS value
    FROM sys.columns c
    INNER JOIN @table2 t2 ON OBJECT_ID(@table2) = t2.object_id
    WHERE c.name NOT IN ('id')
) AS table2
ON table1.name = table2.name
WHERE table1.value <> table2.value

SELECT @columns = LEFT(@columns, LEN(@columns) - 1)

SET @sql = 'SELECT ' + @columns + ' FROM ' + @table1 + ' WHERE id = ' + CONVERT(NVARCHAR(50), @id)
EXEC sp_executesql @sql

SET @sql = 'SELECT ' + @columns + ' FROM ' + @table2 + ' WHERE id = ' + CONVERT(NVARCHAR(50), @id)
EXEC sp_executesql @sql

END

在上述代码中，我们使用了动态SQL语句以及系统存储过程sys.columns来获取列名并生成需要查询的SQL语句。最后，我们使用sp_executesql执行该SQL语句并获取列名不同的结果。