서기의 소소한 이야기 : )

-- 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 = 'Trigg..