CREATE TRIGGER tg_PhongBan_insert
ON PHONGBAN
FOR INSERT
AS 
BEGIN     
    SET NOCOUNT ON 
 
    DECLARE @maphong INT = (SELECT MAPHG FROM inserted)
    DECLARE @tenphong varchar(15) = (SELECT TENPHG from inserted)
 DECLARE @truongphong VARCHAR(9) = (SELECT TRPHG from inserted)
 DECLARE @ngaync DATETIME = (SELECT NG_NHANCHUc from inserted)
    
    IF ((SELECT DATEDIFF(YEAR,NGSINH,GETDATE()) FROM NHANVIEN WHERE @truongphong=MANV)>35)
 PRINT('THEM THANH CONG')
       
    ELSE
  BEGIN
        PRINT('tuoi phai tren 35')
  ROLLBACK
  END
END
GO