ROLLBACK TRANSACTION请求没有相应的BEGIN TRANSACTION。 [英] The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

问题描述

alter procedure bankprocedure
as
begin
begin try
update bank set name='sarika' where money=50000 and type='savings' 
update tblemployee set name='samala' where salary=50000 and gender='female'
commit transaction
end try

begin catch
rollback transaction
end catch
end

显示此错误：



（1行受影响）



（0行（s）受影响）

消息3903，级别16，状态1，程序bankprocedure，第11行

ROLLBACK TRANSACTION请求没有相应的BEGIN TRANSACTION

showing this error:

(1 row(s) affected)

(0 row(s) affected)
Msg 3903, Level 16, State 1, Procedure bankprocedure, Line 11
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

推荐答案

没有BEGIN TRANSACTION进行COMMIT或ROLLBACK ...... !!!在更新查询之前添加BEGIN TRANSACTION。这将解决您的错误。

There is no BEGIN TRANSACTION to COMMIT or ROLLBACK...!!! Add BEGIN TRANSACTION before update query. This will solve your error.

这篇关于ROLLBACK TRANSACTION请求没有相应的BEGIN TRANSACTION。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！