When, I first saw this statement a Hindi proverb come to my mind which is “1 teer 2 nishane” . The meaning of this proverb means a single bow which hit two different aim in one shot. So let me explain “Merge” statement in more detail. With the help of this Merge statement we can …
Problem:- Suppose you have a source table and one destination table and you want to synch destination table from source table. means if record is already exists then you need to update and the record with latest value and insert the record if record is not exists. Solution:- Although there are various ways exist …