Usage of SQL Server merge

CREATE TABLE ttable    (      ID INT,      F1 varchar (ten),      F2 varchar (),      f3 varchar)    Goinsert  Into Ttable   Select one, one,  14INSERT into  ttable Select,  25,26gocreate TABLE ttable2
   (      ID INT,      f5 varchar (ten),      f6 varchar)    gocreate PROC mergetestas    BEGIN        MERGE Into TTable2 T1        USING (SELECT    ID, F3, F2  from  ttable  ) T2 on  (t1.id = t2.id) when        MAT  Ched then  UPDATE SET t1.f5 = t2.f2, T1.f6 = t2.f3 when not        matched then            INSERT (ID, F5, f6)            VALUES ( T2.id, T2.F2, t2.f3);    Endgo

　　

Usage of SQL Server merge