Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as:
IF FOUND
THEN UPDATE
ELSE
INSERT
SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to provide this functionality with a single statement. This allows for code reduction and easier maintainability.
thanks :) very handy indeed!
ferrucciog 1 year ago
the video is reallt blur :( cant see the code
MuslimWanabe 2 years ago