Choose the model

Question

Cho bảng NV(MaNV, …, MaPB), DA(MaDA, …., MaPB) và PB(MaPB, ….).

Viết trigger để khi xóa một PB thì các nhân viên và dự án của phòng ban đó cũng được xóa luôn.

Accepted Answer

CREATE TRIGGER XoaPB
ON PHONGBAN
AFTER Delete
AS
Begin
DECLARE @MaPhg nvarchar(9)

SELECT @MaPhg = MaPB FROM DELETED

IF EXISTS(SELECT * FROM NHANVIEN WHERE MaPB = @MaPhg)
DELETE FROM NHANVIEN WHERE MaPB = @MaPhg

IF EXISTS(SELECT * FROM DEAN WHERE MaPB = @MaPhg)
DELETE FROM DEAN WHERE MaPB = @MaPhg
End

Answer

CREATE TRIGGER XoaPB
ON PHONGBAN
AFTER Delete
AS
Begin
DECLARE @MaPhg nvarchar(9)

SELECT @MaPhg = MaPB FROM DELETED

IF EXISTS(SELECT * FROM NHANVIEN WHERE MaPB = @MaPhg)
DELETE FROM NHANVIEN WHERE MaPB = @MaPhg

End

Answer

CREATE TRIGGER XoaPB
ON PHONGBAN
AFTER Delete
AS
Begin

IF EXISTS(SELECT * FROM NHANVIEN WHERE MaPB = @MaPhg)
DELETE FROM NHANVIEN WHERE MaPB = @MaPhg

IF EXISTS(SELECT * FROM DEAN WHERE MaPB = @MaPhg)
DELETE FROM DEAN WHERE MaPB = @MaPhg
End

Answer

CREATE TRIGGER XoaPB
ON PHONGBAN
AFTER Delete
AS
Begin
DECLARE @MaPhg nvarchar(9)

SELECT @MaPhg = MaPB FROM DELETED

IF EXISTS(SELECT * FROM DEAN WHERE MaPB = @MaPhg)
DELETE FROM DEAN WHERE MaPB = @MaPhg
End

Câu hỏi 967356 - Hệ quản trị CSDL - IT10

DONATE

Bản tin HOU-TV số 06 năm 2025