📄 delclass.sql
字号:
/******辅导员老师被删除时,删除其所管理的所有班级*****/
create TRIGGER DelClass ON Teacher
FOR DELETE
AS
IF @@RowCount=0 Return
Declare @ID int
Select @ID=teacher_id From Deleted
delete from class Where teacher_id = @ID
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -