Advertisement
Guest User

Untitled

a guest
Jun 30th, 2015
206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.31 KB | None | 0 0
  1. MERGE INTO TABLENAME WITH (HOLDLOCK) AS target  
  2.             USING
  3.             (SELECT :id AS id, :lastaccess AS lastaccess ) AS SOURCE
  4.             (id,lastaccess)
  5.             ON
  6.             (target.id = SOURCE.id)
  7.             WHEN MATCHED THEN UPDATE SET lastaccess = :lastaccess2
  8.             WHEN NOT MATCHED THEN INSERT (id, lastaccess)
  9.             VALUES (:id2, :lastaccess3);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement