大家帮我看一下,我的这个游标错在哪里了!
长风dad 2009-02-05 03:38:30 declare youbiao cursor scroll for select StartTime2,EndTime2,[id] from eshow where id<>'' and StartTime2<>''
open youbiao
declare @fff datetime,@ggg datetime,@hhh datetime,@jjj datetime,@iid int
while(@@error=0)
begin
fetch next from youbiao into @fff,@hhh,@iid
print @@fetch_status
set @fff=dateadd(d,-1,@fff)
set @ggg=dateadd(d,-1,@fff)
set @hhh=dateadd(d,1,@hhh)
set @jjj=dateadd(d,1,@hhh)
update eshow set StartTime1=@ggg,EndTime1=@fff,StartTime3=@hhh,EndTime3=@jjj where id=@iid
end
close youbiao
deallocate youbiao
老师们,帮我看以下上面这个游标,为什么在更新表中最后一条记录时,运算出现死循环!