use jxgl
drop trigger tri_xk
go
create trigger tri_xk
on xk
for insert
as
if not exists (
select rk.cno,rk.tno
from inserted ,rk
where rk.cno = inserted.cno and rk.tno = inserted.tno
)
begin
raiserror('添加数据不在任课信息表中,添加记录失败',16,1)--https://www.cnblogs.com/xugang/archive/2011/04/09/2010216.html
--rollback transaction
end
else
begin
print('添加数据在任课信息表中,添加记录成功')
end
go
insert xk(sno,cno,tno,score)
values('S0001','c011','t0001',60)
感觉很奇怪,我的输入是('S0001','c011','t0001',60),输出是
[图片说明](https://img-ask.csdn.net/upload/201912/01/1575134064_316234.jpg)