一样

出现的2条记录分别是什么样的？

比如说@ISDN为MS-0000004
@BookID的两条为MS-0000004-000
MS-0000004-001
其它无论我添加什么样的@ISDN@BookID都只出现末尾为．．．．－０００和．．．．．－００１

我的感觉是字符长度定义和取舍有问题。

不是自己做的东西很难查。

原先我把＠tempBookID长度设置为２，而本来应该是３，所以只有一条记录.......-00，后来我把长度改成３后变成．．．．．．－０００和．．．．．－００１两条记录了．
还有其它存储过程跟这个类似，它就能正确添加记录．
create proc Insert_BookStateInfo
@ISDN varchar(10),
@TotalStock integer
as
begin tran
declare @State varchar(10),@BookID varchar(14),@i integer,@tempBookID varchar(3)
set @i=0
set @State='归还'
while (@TotalStock>@i)
begin
set @tempBookID=(convert(varchar(3),(select max(convert(int,right(BookID,len(BookID)-10)))+1
from BookStateInfo
where ISDN=@ISDN )) )
while (len(@tempBookID)<3)
set @tempBookID='0'+@tempBookID
set @BookID=@ISDN+'-'+@tempBookID
insert into BookStateInfo(ISDN,BookID,State)
values(@ISDN,@BookID,@State)
set @i=@i+1
end
update BookInfo
set TotalStock=isnull(TotalStock,0)+@TotalStock
from BookInfo as a ,BookStateInfo as b
where a.ISDN=b.ISDN and b.ISDN=@ISDN
update BookInfo
set BookStock=isnull(BookStock,0)+@TotalStock
from BookInfo as a ,BookStateInfo as b
where a.ISDN=b.ISDN and b.ISDN=@ISDN
commit

GO