sql if exists update else insert not working - Stack Overflow

Try this: IF EXISTS (SELECT 1 FROM table1 WHERE col_1 = '4') THEN BEGIN UPDATE ...

stackoverflow.com