关于触发器中事务回滚 求助

[heyixiang]

ALTER Trigger trCheckResearchStatus_2
On dbo.research
For Insert,Update
As
Begin transaction
Declare curGetNewID cursor For
Select id,restriction,voteinterval,timeunit from Inserted
Declare @intID int,@inyRestriction tinyint,@intVoteinterval int,@inyTimeunit tinyint
Open curGetNewID
Fetch Next from curGetNewID Into @intID,@inyRestriction,@intVoteinterval,@inyTimeunit
While @@Fetch_Status=0
Begin
If not Exists (Select * From question where reid=@intID)
Update research set status=0 where id=@intID
if @intVoteinterval=0 and @inyRestriction=2
rollback transaction
Fetch Next From curGetNewID into @intID,@inyRestriction,@intVoteinterval,@inyTimeunit
End
Close curGetNewID
Deallocate curGetNewID
Commit transaction


提示 Cimmit transaction请求没有对应的Begin transaction

怎么解决？

[cjxcjx]

begin tran
begin
end
commi
用这总形式

[heyixiang]

cjxcjx(ew)还是没用


提示 Cimmit transaction请求没有对应的Begin transaction

[是是非非]

好像在那个文章里面看到过关于触发器使用事务的
等我找找

[heyixiang]

顶起

[jinjazz]

参考
CREATE TRIGGER trig_customerinfo_deleteupdate
ON customerinfo
FOR UPDATE
AS
If UPDATE(customerno)
BEGIN
select orderid from orderinfo where orderinfo.customerno = (select customerno from deleted)
if @@rowcount > 0
begin
RAISERROR ('不能修改编号，有相应的记录在订单表上', 16, 1)
ROLLBACK TRANSACTION
end
END
GO

[heyixiang]

rollback transaction 是不是不能放到游标中？

jinjazz(近身剪*10年磨一贴) 你给我的参考不能解决我的问题

[heyixiang]

没有人帮忙啊？

[heyixiang]

没人解疑啊