sql 的触发器

create trigger insertSamp 
  on student 
  after insert 
as 
begin 
   print '插入一行数据,操作成功' 
end 


drop trigger insertSamp5 
create trigger insertSamp6 
  on student 
  after insert 
as 
begin 
   delete student where id<6 
   select * from student 
end 




create  
insert into student(stuName,departID,totalScore) values ('三工',1,88) 
  


select * from student 
drop trigger updateStudent1 


create trigger updateStudent1 
   on student 
   for update  
   as 
if update(departID) 
begin    
   update student set totalScore=10 where id=(select id from inserted ) 
end 
drop  trigger updateStudent2 
create trigger updateStudent2 
   on student 
   for update  
   as 
if update(departID) 
begin    
   update student set totalScore=0 where id=(select id from deleted ) 
end 






update student set departID=6 where id=11 




  


create table score 
( 
  id int primary key identity(1,1), 
  stuID int, 
  english int 
) 
go 
insert into score(stuID,english) values (15,80) 
insert into score(stuID,english) values (16,70) 
insert into score(stuID,english) values (17,90) 
insert into score(stuID,english) values (13,99) 




insert into student(stuName,departID,totalScore) values ('ddd',1,80) 
insert into student(stuName,departID,totalScore) values ('fff',2,80) 
insert into student(stuName,departID,totalScore) values ('eee',3,80) 
insert into student(stuName,departID,totalScore) values ('aaaa',1,80) 


  


create trigger delStudent 
  on student 
  for delete 
as 
begin 
   delete score where stuID=(select id from deleted) 
end 


delete student where id=16