I need to create a simple store procedure that can create a record or update based if it exist or not.
I did this:
As you can see i validate if the record exist by finding it base on an input value (unique value) my validation consist in: select count(1) into...
I would like to know if my approach is ok or, is there other better way to perform this operations.
Thanks in advance