22. How to Merge data in SourceTable and TargetTable using Merge statement n SQL Server

MERGE TargetTable AS tgt
USING SourceTable AS src
ON tgt.ID = src.ID
WHEN MATCHED THEN
UPDATE SET
tgt.Name = src.Name,
tgt.Age = src.Age,
tgt.City = src.City
WHEN NOT MATCHED BY TARGET THEN
INSERT (ID, Name, Age, City)
VALUES (src.ID, src.Name, src.Age, src.City)
WHEN NOT MATCHED BY SOURCE THEN
DELETE;