设置游标与游标变量的关联
[code=SQL][/code]declare @stu_c cursor
declare stu_cursor cursor
for
select * from student_info where 性别='男'
set @stu_c=stu_cursor
open @stu_c
fetch next from @stu_c
while @@FETCH_STATUS=0
begin
select * from student_info where
month(出生日期)>=6 and month(出生日期)<=9
fetch next from @stu_c
end
close @stu_c
第五行提示stu_cursor“列名无效”，为什么会这样呢？
实验要求是这样的：声明游标变量@stu_c，使之关联stu_cursor游标，利用@stu_c查询出生日期在6～9月份出生的学生信息。
[解决办法]
declare @stu_c cursor
declare stu_cursor cursor for select * from student_info where 性别='男'
set @stu_c=stu_cursor
open @stu_c
fetch next from @stu_c
while @@FETCH_STATUS=0
begin
select * from student_info where month(出生日期)>=6 and month(出生日期)<=9
fetch next from @stu_c
end
close @stu_c
DEALLOCATE stu_cursor
全选，在执行试试。
