事物为什么不能回滚？？

[OldEagle33032]

DECLARE @PID int


begin tran
INSERT INTO LTCY_QualityFeedBack
(operatorID, Content, OrderID, title, Operatordate)
VALUES (105, '', 1777, '', '2008-7-16 15:02:45')
SET @PID = @@identity
INSERT
INTO LTCY_QualityFeedBackDetail(PID, QualityQuestionID, ClothesID, amount,
memo)
VALUES (@PID, 5, 648, 1, '2')
INSERT
INTO LTCY_QualityFeedBackDetail(PID, QualityQuestionID, ClothesID, amount,
memo)
VALUES (@PID, 7, 6528888888888888888, 3, '4')
rollback tran
commit tran
select @@error+100
if @@error<>0

rollback tran Tran1


最后一条记录没被插入，前二条被插入了，应当要回滚才对也就是都不要插入呀

[whoami333]

关注下。

[HolyPlace]

rollback tran
commit tran
这两个是不能放在一起的吧！

[OldEagle33032]

rollback tran 这个是没有放上去的

[OldEagle33032]

DECLARE @PID int


begin tran
INSERT INTO LTCY_QualityFeedBack
(operatorID, Content, OrderID, title, Operatordate)
VALUES (105, '', 1777, '', '2008-7-16 15:02:45')
SET @PID = @@identity
INSERT
INTO LTCY_QualityFeedBackDetail(PID, QualityQuestionID, ClothesID, amount,
memo)
VALUES (@PID, 5, 648, 1, '2')
INSERT
INTO LTCY_QualityFeedBackDetail(PID, QualityQuestionID, ClothesID, amount,
memo)
VALUES (@PID, 7, 6528888888888888888, 3, '4')
commit tran
select @@error+100
if @@error <>0

rollback tran Tran1

[gordon_two]

在每条语句后判断@ERROR，然后如果<>0使用goto语句到rollback tran，在最后的插入语句判断@error，如果=0 goto到commit tran

[aaajedll]

[Quote=引用 5 楼 gordon_two 的回复:]
在每条语句后判断@ERROR，然后如果 <>0使用goto语句到rollback tran，在最后的插入语句判断@error，如果=0 goto到commit tran
[/Quote]

[whycom]

DECLARE @PID int


begin tran
INSERT INTO LTCY_QualityFeedBack
(operatorID, Content, OrderID, title, Operatordate)
VALUES (105, '', 1777, '', '2008-7-16 15:02:45')
SET @PID = @@identity
INSERT
INTO LTCY_QualityFeedBackDetail(PID, QualityQuestionID, ClothesID, amount,
memo)
VALUES (@PID, 5, 648, 1, '2')
INSERT
INTO LTCY_QualityFeedBackDetail(PID, QualityQuestionID, ClothesID, amount,
memo)
VALUES (@PID, 7, 6528888888888888888, 3, '4')
rollback tran
commit tran
select @@error+100
if @@error <>0
rollback tran Tran1
else
commit ....

[standy]

BEGIN Tran
OTHER SQL
IF @@error<>0
BEGIN
ROLLBACK TRAN
RETURN
END
Commit Tran


缺少了判断报错才回滚的机制

[wangchao1982]

用事务,必然会加上try catch,否则你怎么知道什么时候commit什么时候rollback?
rollback tran
commit tran
放在一起,很无语啊

[yagebu1983]

出现错误后，回滚事务！！！

[万小萌]

楼主没搞清楚sql事务！

[云海ldj]

BEGIN Tran
执行一条SQL语句
IF @@error <>0
BEGIN
ROLLBACK TRAN
RETURN
END
执行一条SQL语句
IF @@error <>0
BEGIN
ROLLBACK TRAN
RETURN
END
.....
Commit Tran

[slimfeng]

弄清事务的概念很重要。

[CityOfAngels]

up

[wptad]

事务回滚是需要条件的

[发表于]

UP

[whoami333]

rollback tran;
return;

不知道这样行不。