USE Study
GO

-- AFTER(FOR) Æ®¸®°Å »ý¼º

CREATE TRIGGER NEW_EMP_SAL
ON EMPLOYEE
FOR INSERT
AS
	BEGIN

	PRINT('NEW_EMP_SAL Trigger is invoked.')

	SELECT * FROM inserted

	UPDATE EMPLOYEE SET SALARY = 100
	FROM inserted, EMPLOYEE
	WHERE inserted.ENO = EMPLOYEE.ENO

	PRINT('Salary of new comer becomes 100')

	SELECT * FROM inserted, EMPLOYEE WHERE inserted.ENO = EMPLOYEE.ENO

	END


-- Å×½ºÆ®
INSERT INTO EMPLOYEE(ENO, ENAME) VALUES(300, 'newcommer')




-- INSTEAD OF Æ®¸®°Å »ý¼º

CREATE TRIGGER NO_UPDATE
ON DEPARTMENT
INSTEAD OF UPDATE
AS
	BEGIN

	PRINT('Update for the DEPARTMENT is prevented')

	END

-- Å×½ºÆ®
SELECT * FROM DEPARTMENT
UPDATE DEPARTMENT SET LOC='SEOUL'
SELECT * FROM DEPARTMENT