Mssql 기본적인 Trigger (Delete)

-- Delete

ALTER trigger [dbo].[utr_mpilb01d] on  [dbo].[mpilb01t]
for delete as
declare @lv_msg            varchar(100),
            @errcode        smallint

update a
   set a.prodqty     = 0
  from mpasg01t a, deleted b
where a.adate     = b.adate
   and a.juya         = b.juya
   and a.machinecd = b.machinecd
   and a.seq       = b.seq

if @@error <> 0
begin
  select @errcode = -1
  goto error_process
end
   
return

-- 에러체크
error_process:

SELECT @lv_msg = 'Trigger DELETE ERROR!~ (mplib01t)' + '(' + convert(varchar,@errcode) + ')'
RAISERROR (@lv_msg, 16, 1)