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