估计是你的触发器用了一个select,修改了@@rowcount 的缘故,触发器改成如下试试:create tigger tiggerName
on info_product_into
for insert
as
set nocount on
declare @Rowc int
select @Rowc=count(*) from info_product_into,inserted
where info_product_into.billno = inserted.bllno
if @rowc >0
begin
raiserror('asdfasd',16,1)
rollback
end
go
on info_product_into
for insert
as
set nocount on
declare @Rowc int
select @Rowc=count(*) from info_product_into,inserted
where info_product_into.billno = inserted.bllno
if @rowc >0
begin
raiserror('asdfasd',16,1)
rollback
end
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货