서기의 소소한 이야기 : )

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

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

-- Insert ALTER trigger [dbo].[utr_mpilb01i] on [dbo].[mpilb01t] for insert as declare @lv_msg varchar(100), @errcode smallint, @gubun char(01), @chk char(01) Set @gubun = (select gubun from inserted) Set @chk = (select chk from inserted) -- 작업지시서 미연결 추가시 자동으로 작업지시 생성 IF (@gubun = 'Y') and (@chk = 'I') BEGIN insert into mpasg01t ( adate, juya, machinecd, seq, itemcd, rank, prodqty, gubun, /*plan..