How To Walk Through All The Columns Of Two Different Table

I am two table. They are backup of each other. I would like to find out what the columns of a row that need to be sync.

For example

Record with ID = 2345, Update Name (From, to) (IreneLee, Irene)
Record with ID = 2345, Update Birthday (From, to) (1975-04-24 , 1975-04-24 )
Record with ID = 4568, Update Name (From, to) (VictorChu, Victor)

I use this statement

with cte1 As
(
Select T1.ID As 'ID',
T1.Name As 'T1Name',
T2.Name As 'T2Name',
T1.Birthday As 'T1Birthday' ,
T2.Birthday As 'T2Birthday'
from T1 inner join T2 on T1.ID = T2.ID
)
Select * from cte1

(eventually I have to programatically generate the above statement)

Below is the result:

ID T1.Name T2.Name T1.Birthday T2.Birthday
--------------------------------------------------------------
1234 Richard Richard 1971-02-09 1971-02-09
2345 IreneLee Irene 1975-04-24 1975-04-24
3456 Danny Danny 1962-09-08 1962-09-08
4568 VictorChu Victor 1962-09-08 1962-09-08

And I use the below script

DECLARE @tableName varchar(max)
Set @tableName= 'T1'
Select column_name From
(
SELECT column_name

[Code] .....

I need to find out what is different between each similar column (e.g. T1.Name and T2.Name) for each row It looks like I need two loop.

This is what the logic I think I need.

For (row in Rows for JoinTable) {
For(column in Columns for ColumnTable) {
if ('T1'.column <> 'T2'.column) {
Insert ('T1.ID' , 'Update T2. ' + column name, 'T1'.column, 'T2'.column)
into #ChangesTable
} } }