advanced code snippet search

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
 
Expand | Embed | Plain Text 
  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.