upsert with addition

Posted by cf_PhillipSenn on Stack Overflow See other posts from Stack Overflow or by cf_PhillipSenn
Published on 2010-05-26T20:34:33Z Indexed on 2010/05/26 20:41 UTC
Read the original article Hit count: 312

IF EXISTS(SELECT * FROM Table WHERE Something=1000)
UPDATE Table SET Qty = Qty + 1 WHERE Something=1000
ELSE
INSERT INTO Table(Something,Qty) VALUES(1000,1)

© Stack Overflow or respective owner