?? declare @PP_id varchar(20),@PP_kk varchar(20) declare @N int set @N=0 declare cur cursor for select PP_id,PP_kk from ProductPrice open cur fetch next from cur into @PP_id,@PP_kk while @@fetch_status=0 begin set @N=@N+1 select @PP_id,@PP_kk fetch next from cur into @PP_id,@PP_kk end close cur deallocate cur
??
declare @PP_id varchar(20),@PP_kk varchar(20)
declare @N int
set @N=0
declare cur cursor for
select PP_id,PP_kk from ProductPrice
open cur
fetch next from cur into @PP_id,@PP_kk
while @@fetch_status=0
begin
set @N=@N+1
select @PP_id,@PP_kk
fetch next from cur into @PP_id,@PP_kk
end
close cur
deallocate cur