2.4.2.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 11 行

use school 
go
create trigger T2 on worker
for delete
as
if (select number from deleted)='00001'
begin
print 'He is the CEO!Delete Fail!'
Rollback transaction
End