下面的过程好象什么都没做呀?
我的目的是要更新我的统计表 Tj,程序可执行,没有错误,但是什么结果都没有
请高手指点一二
CREATE PROCEDURE ATongJi
@wtwt Char(10),
@zrzr Char(10),
@ks DateTime,
@js DateTime,
@myfield Char(2)
AS
Declare @eachfs char(20)
Declare @i int
Declare FangshiCursor Cursor For --定义游标
Select fs from fs
For Read Only --定义游标结束
Open FangshiCursor --打开游标
set @i = 1
While (0=0)
Begin
Fetch Next From FangshiCursor Into @eachfs
If (@@Fetch_Status <> 0) Break
update Tj set @myfield=(
select count(id) from baoxiu
where wt like @wtwt and zr like @zrzr and fs=@eachfs and Sj>=@ks and Sj<=@js)
where id=@i
set @i = @i + 1
End;
Close FangshiCursor
Deallocate FangshiCursor
GO
我的目的是要更新我的统计表 Tj,程序可执行,没有错误,但是什么结果都没有
请高手指点一二
CREATE PROCEDURE ATongJi
@wtwt Char(10),
@zrzr Char(10),
@ks DateTime,
@js DateTime,
@myfield Char(2)
AS
Declare @eachfs char(20)
Declare @i int
Declare FangshiCursor Cursor For --定义游标
Select fs from fs
For Read Only --定义游标结束
Open FangshiCursor --打开游标
set @i = 1
While (0=0)
Begin
Fetch Next From FangshiCursor Into @eachfs
If (@@Fetch_Status <> 0) Break
update Tj set @myfield=(
select count(id) from baoxiu
where wt like @wtwt and zr like @zrzr and fs=@eachfs and Sj>=@ks and Sj<=@js)
where id=@i
set @i = @i + 1
End;
Close FangshiCursor
Deallocate FangshiCursor
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货