Bài CSDL nâng cao 14/15

--------------------2.6----------------------
CREATE TRIGGER TG_GIAOHANG_SLGIAO ON CHI_TIET_GIAO_HANG
FOR INSERT,UPDATE AS
BEGIN
DECLARE @SOLANGIAO INT , @SOGH INT
SELECT @SOGH=SOGH FROM INSERTED
SELECT @SOLANGIAO = COUNT (*) FROM CHI_TIET_GIAO_HANG WHERE @SOGH=SOGH
IF (@SOLANGIAO > 2)
BEGIN
PRINT 'QUA LAN GIAO'
ROLLBACK TRAN
END
ELSE
BEGIN
PRINT 'GIAO THANH CONG'
COMMIT TRAN
END
END

--------------------2.7----------------------
CREATE TRIGGER TG_KIEMTRA ON GIAO_HANG
FOR INSERT,UPDATE AS
BEGIN
DECLARE @SODH INT , @NGAY INT
SELECT @SODH=SODH FROM INSERTED
SELECT @NGAY=DATEDIFF(DD,D.NGAYDAT,G.NGAYGIAO) FROM DAT_HANG D, GIAO_HANG G WHERE @SODH=G.SODH
IF (@NGAY > 7 )
BEGIN
PRINT 'QUA HAN GIAO'
ROLLBACK TRAN
END
ELSE
BEGIN
PRINT 'GIAO THANH CONG'
COMMIT TRAN
END
END