Update with transaction and error handling

create procedure [dbo].[SK_upd_AppealCode] @productid int, @appealcode varchar(20) as begin declare @err_message varchar(2000) declare @err_occurred bit set @err_message = '' set @err_occurr...