create trigger tri
on table
for insert
as
declare @s varchar(2)
declare @s1 varchar(2)
select @s=Sno,@s1=Cno from inserted
if
(select count(*) from table where Sno=@a and Cno =@s1)>0
begin
print'已经存在'
rollback transaction
end
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024