You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
48 lines
701 B
48 lines
701 B
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
|
|
|