create proc usp_AddCourse
(
@Course_CNO int
)
as
if not exists(select CNO from Course where (@Course_CNO = CNO))
insert ....-- 执行插入
else
begin
raiserror('请输入课程号，%d不在Course中,请重新输入！',16,2,@Course_CNO)
end
create trigger Course_CNO_List
on Course
for insert
as
begin
declare @Course_CNO int
select @Course_CNO=CNO from inserted
if exists(select 1 from inserted where cno not in(select CNO from Course))
begin
raiserror('请输入课程号，%d不在Course中,请重新输入！',16,2,@Course_CNO)
rollback transaction
end
end
