-- TRIGGER
--1>
CREATE TRIGGER TR_DELETE
ON MonHoc
FOR DELETE
AS
DECLARE @MaMon VARCHAR(10)
SELECT @MaMon=MaMon  FROM  DELETED
PRINT'BAN ĐÃ XÓA THÀNH CÔNG'
-- Câu truy vấn
DELETE FROM MonHoc WHERE MaMon='M0001'

--TRIGGER
--2
 CREATE TRIGGER TR_INSERT_DangKy
 ON DangKy
 FOR INSERT
 AS
 DECLARE @MaSV VARCHAR(10)
 DECLARE @MaMon VARCHAR(10)
 DECLARE @HocKy SMALLINT
  SELECT FROM dang