UPSERT statement
455593Mar 22 2006 — edited Mar 22 2006I have a question about MERGE... WHEN MATCHED...THEN UPDATE...WHEN NOT MATCHED...THEN INSERT.
Let's say we want to insert when not matched,
but we want to do nothing when matched, what would be the syntax?
MERGE... WHEN MATCHED...THEN UPDATE...WHEN NOT MATCHED...THEN NULL doesn't work.