Skip to content

Instantly share code, notes, and snippets.

@turing85
Last active February 10, 2023 12:31
Show Gist options
  • Save turing85/bd94a451abbc7a768318422eff2f6c30 to your computer and use it in GitHub Desktop.
Save turing85/bd94a451abbc7a768318422eff2f6c30 to your computer and use it in GitHub Desktop.
MERGE INTO some_table AS saved
USING (
VALUES (?, ?, ?, CURRENT_TIMESTAMP)
) AS param (
servicename,
processorname,
messageId,
createdat
)
ON (
saved.servicename = param.servicename AND
saved.processorname = param.processorname AND
saved.messageId = param.messageId)
WHEN NOT MATCHED THEN
INSERT (servicename, processorname, messageId, createdat)
VALUES (param.servicename, param.processorname, param.messageId, param.createdat)
WHEN MATCHED THEN
UPDATE SET createdat = param.createdat, done = false;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment