MyITGuy
11/9/2014 - 5:01 PM

SQL: If Exists Update Else Insert

SQL: If Exists Update Else Insert

better_update_insert.sql
content_copyfile_download
UPDATE Table1 SET (...) WHERE Column1='SomeValue'
IF @@ROWCOUNT=0
    INSERT INTO Table1 VALUES (...)