Comparing contents of two tables without hardcoding field names

[bbbasket]

Is there a way to compare the data in two tables without
hardcoding every field? I want to cycle thru each field name by somehow referencing the properties of a table.

 

[cmmrfrds]

Here is where the tables and column names are in Sql Server
select SO.Id,
TableName = SO.Name,
ColumnName = SC.name

from Sysobjects SO
Inner join Syscolumns SC on SO.id = SC.id
where SO.TYpe = 'U'