Thanks! We'll email you
when relevant content is
added and updated.
In our SQL Server database, we have a table structure like this:
MyTable(KEY, datafield1, datafield2...)
Sometimes, we need to either update an existing record or just insert a new one if you doesn't exist. Basically, this is what we want to run:
IF (key exists)
run update command
run insert command
What would be the best way to write this? Thank you so much.