创建studentcourse(学号,姓名,课程1,课程2...) information(学号,姓名,性别,籍贯,联系电话....) 两张表
更新型触发器(update):
Create Trigger T1
On studentcourse --在Studentcourese表中创建触发器
for Update --为什么事件触发
As --事件触发后所要做的事情
if Update(姓名)
begin
Update information
Set 姓名=i.姓名
From information inf, Deleted d ,Inserted i --Deleted和Inserted临时表
Where inf.学号=d.学号
end
删除型触发器(delete):
Create trigger T2
On Studentcourse
for Delete
As
Delete information
From information inf, Deleted d
Where inf.学号=d.学号
插入型触发器(insert):
Create trigger T3
On Studentcourse
for INSERT
As
INSERT into information(学号,姓名)
select i.学号,i.姓名
from studentcourse sc,inserted i
where sc.学号=i.学号