Sunday, February 4, 2018

Update Not Found Then Insert

UPDATE Table1 SET (...) WHERE Column1='SomeValue'
IF @@ROWCOUNT=0
    INSERT INTO Table1 VALUES (...)
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)