creat trigger mytrigger
after insert
on produce
for each row
begin
if ((select leftCount from inserted)<=10)
then
rollback transaction
raiserroe('error',16,1)
end if
end
就是如果leftcount小于10 的话拒绝插入
creat trigger mytrigger
after insert
on produce
for each row
begin
declare @a int
select @a=count(leftCount) from inserted
if (@a>10)
then
rollback transaction
raiserroe('error',16,1)
end
end
after insert
on produce
for each row
begin
declare @a int
select @a=count(leftCount) from inserted
if (@a>10)
then
rollback transaction
raiserroe('error',16,1)
end
end
温馨提示：答案为网友推荐，仅供参考
