第1个回答 2013-12-30
createtrigger tri_student_course
on student_course
forinsert
as
begin
declare @nMark float,@eMark float
declare @sNo varchar(10),@ccNo char(10)
select @nMark=NormalMark,@eMark=ExamMark,@sNo=sno,@ccNo=ccNO
from inserted
update student_course
set mark=convert(int,@nMark*0.2+@eMark*0.8)
where sNo=@sNo and ccNo=@ccNo
end
其中的判断我也不知道怎么做大概是if exists(select * from syscolumns whereid=object_id('student_course') and name='sno')
但是一加进去就会报错。本回答被网友采纳