提示"没有找到任何该名称的事务或保存点",???????????

[j99616]

CREATE PROCEDURE dbo.BillInsert
(
@SN int,
@TopNumber int,
@BottomNumber int,
@Total int,
@DealNumber int,
@SpareNumber int,
@AddUser int,
@AddDatetime datetime,
@ReckoningUser int,
@ReckoningDatetime datetime,
@IfReckoning bit
)
AS

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
begin tran addrow
SET NOCOUNT OFF;
INSERT INTO Bill(SN, TopNumber, BottomNumber, Total, DealNumber, SpareNumber, AddUser, AddDatetime, ReckoningUser, ReckoningDatetime, IfReckoning) VALUES (@SN, @TopNumber, @BottomNumber, @Total, @DealNumber, @SpareNumber, @AddUser, GETDATE(), @ReckoningUser, @ReckoningDatetime, @IfReckoning);

if((SELECT COUNT(ID) AS number FROM Bill WHERE (IfReckoning = 0) AND (TopNumber <= @bottomNumber) AND (BottomNumber >= @topNumber))=1)

begin
commit tran addrow
SELECT ID, SN, TopNumber, BottomNumber, Total, DealNumber, SpareNumber, AddUser, AddDatetime, ReckoningUser, ReckoningDatetime, IfReckoning FROM Bill WHERE (ID = @@IDENTITY)
end

else

begin
rollback tran addrow
INSERT INTO DealInfo([ID]) VALUES(-1)
end
GO



运行后提示
无法回滚 addrow。没有找到任何该名称的事务或保存点。

[xspf]

CREATE PROCEDURE dbo.BillInsert
(
@SN int,
@TopNumber int,
@BottomNumber int,
@Total int,
@DealNumber int,
@SpareNumber int,
@AddUser int,
@AddDatetime datetime,
@ReckoningUser int,
@ReckoningDatetime datetime,
@IfReckoning bit
)
AS
DECLARE @Count int

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
begin tran addrow
SET NOCOUNT OFF;
INSERT INTO Bill(SN, TopNumber, BottomNumber, Total, DealNumber, SpareNumber, AddUser, AddDatetime, ReckoningUser, ReckoningDatetime, IfReckoning) VALUES (@SN, @TopNumber, @BottomNumber, @Total, @DealNumber, @SpareNumber, @AddUser, GETDATE(), @ReckoningUser, @ReckoningDatetime, @IfReckoning);

SELECT @Count = COUNT(ID) AS number FROM Bill WHERE (IfReckoning = 0) AND (TopNumber <= @bottomNumber) AND (BottomNumber >= @topNumber)

if(@Count=1)

begin
commit tran addrow
SELECT ID, SN, TopNumber, BottomNumber, Total, DealNumber, SpareNumber, AddUser, AddDatetime, ReckoningUser, ReckoningDatetime, IfReckoning FROM Bill WHERE (ID = @@IDENTITY)
end

else

begin
rollback tran addrow
INSERT INTO DealInfo([ID]) VALUES(-1)
end
GO

[wyb0026]

小小

[xspf]

if((SELECT COUNT(ID) AS number FROM Bill WHERE (IfReckoning = 0) AND (TopNumber <= @bottomNumber) AND (BottomNumber >= @topNumber))=1)

有错误吧