Skip to Content

Sap hana store procedure insert, update operation

Jul 23, 2017 at 11:05 PM


avatar image
Former Member


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

captura.png (29.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers