Mssql 기본적인 Trigger (Update)

-- Update

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

update a
   set a.prodqty     = b.workqty
  from mpasg01t a, inserted 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 UPDATE ERROR!~ (mplib01t)' + '(' + convert(varchar,@errcode) + ')'
RAISERROR (@lv_msg, 16, 1)