trigger 触发器

--trigger
--在SC表上建了一个触发器，查看inserted和deleted表中内容。
create trigger tri_1 on sc
for insert,update,delete
as
--declare @a int
select * from inserted
select * from deleted
go
drop trigger tri_1
go
insert into sc
values('200215122','1',87)
go
update sc
set grade=90 where sno='200215122' and cno='1'
go
select * from sc
select * from student
select * from course
go
create trigger tri_2 on student
for insert
as
select * from inserted
declare @a smallint
select @a=sage from inserted
if @a<14 
update student
set sage=18 where sno=(select sno from inserted)
go
drop trigger tri_2
go
insert into student
values('200215127','liusi','男',12,'cs')
go drop table teacher
CREATE TABLE teacher
(Eno    char(4) primary key,
 Sal     smallint,
 tname  char(10),
 job char(8) )
go 
create trigger tri_2 on teacher
for insert
as
declare @a char(8) 
select @a=job from inserted
if @a='教授' and 4000>(select sal from inserted) 
update teacher
set sal=4000 where eno=(select eno from inserted)
go
insert into teacher 
values('1001',3000,'pro_zhang','教授')
go
select * from teacher
go 

　　

转载于:https://www.cnblogs.com/wc1903036673/p/3413061.html