document.sql

来自「vc++6.0数据库编程大全一书得各个章节得源码,比较详细.可以仔细参照学习!」· SQL 代码 · 共 25 行

Create Trigger DELETEDEPARTMENT
On DEPARTMENT
For DELETE
As

DECLARE @count tinyint,
        @errors tinyint
SET @errors = 0
SELECT @count = COUNT(*) 
FROM Instructor e INNER JOIN deleted d ON e.DepartmentCode = d.DepartmentCode 
IF (@count > 0)
BEGIN
    RAISERROR ('Instructor has related records so this department cannot be deleted', 16, 1)
	SET @errors = @errors + 1
END
SELECT @count = COUNT(*) 
FROM Class c INNER JOIN deleted d ON c.DepartmentCode = d.DepartmentCode 
IF (@count > 0)
BEGIN
    RAISERROR ('Class has related records so this department cannot be deleted', 16, 1)
	SET @errors = @errors + 1
END
IF (@errors > 0)
	ROLLBACK TRANSACTION