SQL实现触发器

发布网友发布时间：2022-04-07 23:02

共1个回答

热心网友时间：2022-04-08 00:31

--(1)
create trigger trigCourseInserton on Course for insert as
   print '你正在插入课程信息'
go

--(2)
create trigger trigCourseUpdate on course for update as
declare @YKC as varchar(10)=(select Cname from deleted)
declare @XKC as varchar(10)=(select Cname from inserted)
print '原课程：'+@YKC+' 新课程：'+@XKC
go

--(3)
create trigger trigStudentDelete on Student for delete as
insert into 毕业生表 select * from deleted
go

--(4)
create trigger triSCInsert on SC instead of insert as
if not exists(select * from Course join inserted on Course.Cno=inserted.Cno)
   begin
      print '课程表中没有改课程！'
  rollback
   end

追问谢谢

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com