[SQLServer] 삭제 테이블 로그 남기기...트리거에서 남겨봅시다.
CREATE TRIGGER [dbo].[Trg_twWHInventoryNew2]
ON [dbo].[twWHInventoryNew2]
AFTER DELETE -- 삭제 작업시 작동하도록 지정
AS
INSERT INTO emp_delete (shipperCode)
SELECT shipperCode FROM deleted
GO
ON [dbo].[twWHInventoryNew2]
AFTER DELETE -- 삭제 작업시 작동하도록 지정
AS
INSERT INTO emp_delete (shipperCode)
SELECT shipperCode FROM deleted
GO