使用T_SQL怎么将一个列值赋给一个变量

[jieguo]

use bdxfczdb
go


declare


mycur CURSOR for
select sum(czd) as zds,cardid from xxk
where xfrq<'2004-7-1' and xfrq>='2004-6-1'
group by cardid


open mycur

declare @points float
declare @card char(10)
set @points =0
set @card=''

fetch next from mycur
while (@@Fetch_status=0)
begin
set @points=zds //执行出错,zds无效
set @card=cardid //error
print @points//这里是其他 操作

fetch next from mycur
end
close mycur
deallocate mycur
go
就是想逐条记录把一个字段值取出,再进行别的操作,但是不行,谁能帮我想个办法

[pisces007]

fetch next from mycur into @定义变量

[pisces007]

即fetch next from mycur into @points,@card

[jieguo]

额外问一个问题,第一条fetch next from mycur语句是把游标定位到第一条么,还是定位到第二条记录

[zjcxc]

use bdxfczdb
go

declare mycur CURSOR for
select sum(czd) as zds,cardid from xxk
where xfrq<'2004-7-1' and xfrq>='2004-6-1'
group by cardid

open mycur

declare @points float
declare @card char(10)

fetch next from mycur into @points,@card
while (@@Fetch_status=0)
begin
print @points --//这里是其他 操作

fetch next from mycur into @points,@card
end
close mycur
deallocate mycur
go

[jieguo]

先谢谢蝶鱼,象个女孩名哎

[zjcxc]

open mycur 游标位在第一条记录

第一条fetch next from mycur 取出记录,游标定位到第二条记录

@@Fetch_status 判断最近一条 fetch next from mycur 的取数是否成功

[pisces007]

呵呵，
第一条fetch next from mycur语句是把游标定位到第一条

[jieguo]

哦,再次感谢