那位哥哥帮小弟看哈我的存储过程的问题哈～！
ALTER PROCEDURE [dbo].[sp_DelBillProduct]
(
@BPID int
)
AS
BEGIN
declare @BID int,@TotalCount int, @OverCount int,@Flag int
begin tran
delete TBillProduct where BPID = @BPID
select @BID = BID from TBillProduct where BPID = @BPID
select @TotalCount = TotalCount,@OverCount = OverCount,@Flag = Flag from TBill where BID = @BID
if @@error<>0
begin
ROLLBACK TRAN
return
end
if @TotalCount -1 = 0
begin
set @Flag = 1
end
else
begin
if @OverCount = @TotalCount -1
begin
set @Flag = 2
end
end
declare @Remain int
set @Remain = @TotalCount -1
update TBill set TotalCount = @Remain,Flag = @Flag where BID = @BID
-- select @TotalCount-1 as Remain,@OverCOunt,@Flag
if @@error<>0
begin
ROLLBACK TRAN
return
end
commit tran
END
update TBill set TotalCount = @Remain,Flag = @Flag where BID = @BID没有执行！
而我测试用select都时正常的。为什么啊？晕啊
问题点数：20、回复次数：4Top
1 楼jeanso（轩辕剑）回复于 2006-07-04 14:08:56 得分 0
没人知道啊？Top
2 楼jeanso（轩辕剑）回复于 2006-07-04 14:58:23 得分 0
唉，原来先删除哈。晕～
谁顶谁得分哈Top
3 楼shunbing（）回复于 2006-07-04 15:22:26 得分 20
恭喜楼主，接分Top
4 楼longwycn（(理想0769) ---要做DBA）回复于 2006-07-04 15:35:08 得分 0
恭喜楼主，接分
Top
