Differentiate Between ‘insert Or Update’ And ‘update Or Insert�

1.	Differentiate Between ‘insert Or Update’ And ‘update Or Insert’?
Answer» Insert or UPDATE means FIRST we insert a RECORD, but if a record is MATCHING with the primary key then the record is updated. Update or insert means first we update the record with same primary and if the record doesn’t EXISTS then we insert the record.

Differentiate Between ‘insert Or Update’ And ‘update Or Insert’?

Answer»

Insert or UPDATE means FIRST we insert a RECORD, but if a record is MATCHING with the primary key then the record is updated.
Update or insert means first we update the record with same primary and if the record doesn’t EXISTS then we insert the record.