개발 참고자료

ALTER TRIGGER [dbo].[ut_al_mst_update]
ON [dbo].[AL_MST]
FOR UPDATE
AS
BEGIN
DECLARE @ls_req_seq VARCHAR (12)
DECLARE @ls_appr_cat VARCHAR (12)

IF update (appr_cat)
BEGIN
SELECT @ls_req_seq = req_seq,
@ls_appr_cat = appr_cat
FROM inserted

IF @ls_appr_cat = 'END'
BEGIN
UPDATE dbo.al_mst
SET appr_cat_end_dt =
REPLACE (
REPLACE (
REPLACE (CONVERT (VARCHAR, GETDATE (), 120),
'-',
''),
':',
''),
' ',
'')
WHERE 1 = 1 AND req_seq = @ls_req_seq
END
END
END