创建instead of 触发器,当要删除选课表中记录时,触发器被触发阻止删除操作,并显示“成绩数据不允许删除!”
Create trigger t1
On 选课表 instead of delete
As
Rollback transaction
Print'成绩数据不允许删除!'
创建instead of 触发器,当要删除选课表中记录时,触发器被触发阻止删除操作,并显示“成绩数据不允许删除!”
Create trigger t1
On 选课表 instead of delete
As
Rollback transaction
Print'成绩数据不允许删除!'