Написание запроса на изменение данных

update t1 set t1.d17 = (select d22 from t1 as t11 where t11.n12 = t1.n12), t1.d18 = (select d22 from t1 as t11 where t11.n12 = t1.n12), t1.d19 = (select d22 from t1 as t11 where t11.n12 = t1.n12)

update t2 set d2_1 = (select t1.d22 from t1 where t1.n12 = t2.n12), d2_4 = (select t1.d22 from t1 where t1.n12 = t2.n12)

update t1 set t1.d17 = 
dateadd(millisecond, datepart(ms,datetimeCol),
dateadd(second,datepart(ss,datetimeCol),
dateadd(minute,datepart(mm,datetimeCol),
dateadd(hour,datepart(hh,datetimeCol),
Cast((SELECT d22 FROM t1 AS t11 WHERE t11.n12 = t1.n12)as datetime)))))

update t1 set t1.d17 = Cast(t1.d17 as time) + Cast((SELECT d22 FROM t1 AS t11 WHERE t11.n12 = t1.n12)as datetime)

UPDATE T1 SET T1.d17 = T1.D22 from T1 WHERE T1.N12 = 123 and T1.N12 = 123;
UPDATE T1 SET T1.d18 = T1.D22 from T1 WHERE T1.N12 = 123 and T1.N12 = 123;
UPDATE T1 SET T1.d19 = T1.D22 from T1 WHERE T1.N12 = 123 and T1.N12 = 123;
UPDATE T2 SET T2.d2_1 = T1.D22 from T2, T1 WHERE T2.N12 = 123 and T1.N12 = 123;
UPDATE T2 SET T2.d2_4 = T1.D22 from T2, T1 WHERE T2.N12 = 123 and T1.N12 = 123;
UPDATE T3 SET T3.d12 = T1.D22 from T3, T1 WHERE T3.N12 = 123 and T1.N12 = 123;
UPDATE T4 SET T4.d45 = T1.D22 from T4, T1 WHERE T4.N12 = 123 and T1.N12 = 123;

UPDATE T1 SET T1.d17 = CAST(T1.D17 AS TIME) + CAST(T1.D22 AS DATETIME) FROM T1 WHERE T1.N12 = 123 AND T1.N12 = 123;

update table_name set d86 = '20111231 12:00:04'
where d86 = '20110930 12:35:00' and n14 = 569