서기의 소소한 이야기 : )

-- 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..