要實現的效果是：如果傳進去的@cyid=0，則把chengyuan表中所有成員的cyoffer 和cyreturn改變；如果傳進去的@cyid!=0,且@cyid是chengyuan表中的成員id,則，改變當前id對應的cyoffer 和cyreturn值。 結算存儲過程如下 ---------------------------成員結算----------------create proc sp_jiesuan@cyid int ,--要結算的成員id，如果id為零則將所有成員結算@jiesuane numeric(18,2)--結算額asset nocount on set rowcount 0set transaction isolation level read uncommitted declare @error_no integer, --錯誤號 @error_info varchar(255)---錯誤信息 select @error_no =0, @error_info ='' select @cyid=isnull(@cyid,0), @jiesuane =isnull(@jiesuane,0.00)begin transaction declare @yingfu numeric(18,2)if @cyid=0begindeclare @icy intselect @icy=1while @icy<=(select count(cyid) from chengyuan)begindeclare @id int select @id=(select top 1 cyid from chengyuan where cyid not in( select top (@icy-1) cyid from chengyuan order by cyid asc) order by cyid asc), @yingfu= ((select cyreturn from chengyuan where cyid=@id)-(select cyoffer from chengyuan where cyid=@id))if @yingfu>@jiesuaneupdate chengyuan set cyoffer=cyoffer+@jiesuane where cyid=@idelse if @yingfu=@jiesuaneupdate chengyuan set cyoffer=0 ,cyreturn=0 where cyid=@idelse if @yingfu<@jiesuaneupdate chengyuan set cyoffer=@jiesuane-@yingfu ,cyreturn=0 where cyid=@idset @icy=@icy+1endendelse --declare @icy1 int--select @icy1=1if @cyid in (select cyid from chengyuan)beginselect @yingfu=(select cyreturn from chengyuan where cyid=@cyid)-(select cyoffer from chengyuan where cyid=@cyid)if @yingfu>@jiesuaneupdate chengyuan set cyoffer=cyoffer+@jiesuane where cyid=@cyidelse if @yingfu=@jiesuaneupdate chengyuan set cyoffer=0 ,cyreturn=0 where cyid=@cyidelse if @yingfu<@jiesuaneupdate chengyuan set cyoffer=@jiesuane-@yingfu ,cyreturn=0 where cyid=@cyidendcommit transactionif @error_no!=0 return @error_noreturn 0 問題是：其中當@cyid=0時，為什么chengyuan表中cyid=1的那條數據沒有改變，其他的數據均改變了？