mssql_Study/trigger_dml.sql

USE Study
GO

-- AFTER(FOR) Ʈ<EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>

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


-- <EFBFBD>׽<EFBFBD>Ʈ
INSERT INTO EMPLOYEE(ENO, ENAME) VALUES(300, 'newcommer')




-- INSTEAD OF Ʈ<EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>

CREATE TRIGGER NO_UPDATE
ON DEPARTMENT
INSTEAD OF UPDATE
AS
	BEGIN

	PRINT('Update for the DEPARTMENT is prevented')

	END

-- <EFBFBD>׽<EFBFBD>Ʈ
SELECT * FROM DEPARTMENT
UPDATE DEPARTMENT SET LOC='SEOUL'
SELECT * FROM DEPARTMENT