>Hi,
>
>How do you INSERT (possibly) and UPDATE a table in one command? Here is what I am trying to do:
>
>I need set fields, say MyField1 and MyField2, to some values MyVal1 and MyVal2 in a table where field MyField3 is equal to ‘MyVal3’ But if the record where MyField3 = ‘MyVal3’ does not exist, I want to INSERT a record and set values of all three fields.
>
>TIA
In SQL Server 2008 and up you need to use MERGE command. Start from looking at MERGE command examples in BOL.
Otherwise the basic idea is to use IF NOT EXISTS (..) INSERT ELSE UPDATE pattern which may fail in multi-user environment.
If it's not broken, fix it until it is.
My Blog