Hi,

Your Requirement is fulfilled easily in SQLserver2008.

In SQLserver2008 there is a concept called Merge.with this the performane is also improoved.

Try the following query.

MERGE INTO TableB AS Target

USING TableA AS Source

ON Target.Sid =Source.Sid AND Target.Mid =Source.Mid

WHEN MATCHED THEN

UPDATE SET Target.Fname = Source.Fname ,

Target.Age = Source.Age ,

Target.Address = Source.Address

WHEN NOT MATCHED BY TARGET THEN

INSERT (Sid,Mid,Fname,Age,Address)

VALUES (Source.Sid,Source.Mid,Source.Fname,

Source.Age,Source.Address);

--PS:Don't forget ';' (Semicolun) at the end.

To execute the above query you need SqlServer2008. Other wise it'll give error.