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
Leave a comment: