我有一个百万数据库,需要循环取值进行计算,现在是用游标每次只能取88888 条记录,超过十万,就根本算出来,这样很麻烦,哪位有没有百万数据库循环取值进行更新的算法 ,begin Declare GuestCursor Cursor For
Select top 88888 XLH,SL from CP_SSQ6_005 where xtbz='0' order by XLH asc;
Open GuestCursor
Fetch Next From GuestCursor into @V_XLH,@V_SL;
WHILE @@FETCH_STATUS = 0
Begin
update CP_SSQ6_005 set xtbz='1' where xlh=@V_XLH; set @V_SL=rtrim(ltrim(@V_SL));
set @V_1=substring(@V_SL,1,2);
set @V_2=substring(@V_SL,3,2);
set @V_3=substring(@V_SL,5,2);
set @V_4=substring(@V_SL,7,2);
set @V_5=substring(@V_SL,9,2);
set @V_6=substring(@V_SL,11,2); Select @V_or=dbo.F_GetOrder_2_3(@V_SL)
set @T_1=CAST(@V_1 AS decimal(18,0))
set @T_2=CAST(@V_2 AS decimal(18,0))
set @T_3=CAST(@V_3 AS decimal(18,0))
set @T_4=CAST(@V_4 AS decimal(18,0))
set @T_5=CAST(@V_5 AS decimal(18,0))
set @T_6=CAST(@V_6 AS decimal(18,0)) set @T_JE=@T_1+@T_2+@T_3+@T_4+@T_5+@T_6;
if(@T_JE>=121)
begin
update CP_SSQ6_005 set scbz='1',xtbz='1' where xlh=@V_XLH;
waitfor delay '00:00:00';--
end;
Fetch Next From GuestCursor into @V_XLH,@V_SL;
end
Close GuestCursor
DealLocate GuestCursor
end
Select top 88888 XLH,SL from CP_SSQ6_005 where xtbz='0' order by XLH asc;
Open GuestCursor
Fetch Next From GuestCursor into @V_XLH,@V_SL;
WHILE @@FETCH_STATUS = 0
Begin
update CP_SSQ6_005 set xtbz='1' where xlh=@V_XLH; set @V_SL=rtrim(ltrim(@V_SL));
set @V_1=substring(@V_SL,1,2);
set @V_2=substring(@V_SL,3,2);
set @V_3=substring(@V_SL,5,2);
set @V_4=substring(@V_SL,7,2);
set @V_5=substring(@V_SL,9,2);
set @V_6=substring(@V_SL,11,2); Select @V_or=dbo.F_GetOrder_2_3(@V_SL)
set @T_1=CAST(@V_1 AS decimal(18,0))
set @T_2=CAST(@V_2 AS decimal(18,0))
set @T_3=CAST(@V_3 AS decimal(18,0))
set @T_4=CAST(@V_4 AS decimal(18,0))
set @T_5=CAST(@V_5 AS decimal(18,0))
set @T_6=CAST(@V_6 AS decimal(18,0)) set @T_JE=@T_1+@T_2+@T_3+@T_4+@T_5+@T_6;
if(@T_JE>=121)
begin
update CP_SSQ6_005 set scbz='1',xtbz='1' where xlh=@V_XLH;
waitfor delay '00:00:00';--
end;
Fetch Next From GuestCursor into @V_XLH,@V_SL;
end
Close GuestCursor
DealLocate GuestCursor
end
解决方案 »
- Windows服务生成Excel的问题
- image控件问题..
- 第一次用VSS的问题
- 请教高人一个_用C#向SqlServer2005中添加数据的小问题,急~~
- 如注册用户界面,界面包含 有户名,密码,和上传头文件,如何实现当提交后提示用户名已存在(或刷新界面)后,上传文件控件(FileUpLoad控件)内容不清空?
- 怎样将这两个字符串合并,并且重复的只显示一次。
- 我在配置web.config的appSettings项时候,"出现一个意外的标记"~~(10')
- 关于发送附件的问题
- .NET Framework我已经安装了,但是执行aspx文件出现下列错误!
- 请问写asp.net用哪一种编辑器较好;editplus不支持aspx!!!
- 求助 谁有连接 SQL2005的数据库连接字符串 帮我提供一个 我不知道怎么写
- SkinPP换肤软件如何实现动态地切换皮肤?
http://topic.csdn.net/u/20090305/16/228a3001-f957-40ee-a765-0ff7063e263c.html