PHP Code:
CREATE TRIGGER INT_UP_KHOA
ON KHOA
FOR INSERT,UPDATE
AS
BEGIN
IF(EXISTS(SELECT * FROM INSERTED A,GIAOVIEN B
WHERE (A.TRGKHOA=B.MAGV AND HOCVI NOT IN("TIEN SI"))))
BEGIN
ROLLBACK TRAN
END
END
![Big Grin](https://forum.uit.edu.vn/core/images/smilies/biggrin.png)
Leave a comment: