SQLServer同步两个表的资料

MERGE INTO [dbo].[StudentsB]  AS T USING [dbo].[StudentsA]  AS S ON T.[ID]=S.[ID]
WHEN MATCHED THEN                --当ON条件成立时，更新数据。
    UPDATE SET T.[phone_number]=S.[phone_number]
WHEN NOT MATCHED THEN            --当源表数据不存在于目标表时，插入数据。
    INSERT VALUES (S.[Name],S.[AGE],S.[phone_number]) ---S.[ID]
WHEN NOT MATCHED BY SOURCE THEN  --当目标表数据不存在于源表时，删除数据。
    DELETE;

UPDATE B SET B.[phone_number] = A.[phone_number] FROM [dbo].[StudentsA] AS A,[dbo].[StudentsB] AS B
WHERE B.[id] =A.[id]