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
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