CREATE TRIGGER [del_学生信息] ON [dbo].[学生信息]
FOR DELETE
AS
declare @id int
select @id=学号 from deleted
delete from 成绩 where 学号=@id
delete from 选修课 where 学号=@id
delete from 奖惩登记 where 学号=@id
FOR DELETE
AS
declare @id int
select @id=学号 from deleted
delete from 成绩 where 学号=@id
delete from 选修课 where 学号=@id
delete from 奖惩登记 where 学号=@id
FOR DELETE
AS
declare @id int
select @id=学号 from deleted
delete from 成绩 where 学号=@id
delete from 选修课 where 学号=@id
delete from 奖惩登记 where 学号=@id就是这样撒~但最好不要用触发器,多用存储过程比较稳健~