Posted By

pauliehaha on 02/17/09


Tagged


Versions (?)

Who likes this?

8 people have marked this snippet as a favorite

nickelstar
jamesming
Plastyksouljah
dosullivan
nefd
ckayra
ljayz
dext


If Exists Update Else Insert


 / Published in: SQL
 

  1. UPDATE Table1 SET (...) WHERE Column1='SomeValue'
  2. IF @@ROWCOUNT=0
  3. INSERT INTO Table1 VALUES (...)

Report this snippet  

You need to login to post a comment.