游标: 为什么@@cursos_rows不能正确的返回行数?
有如下游标:
declare @cur_rowCount int
declare AppointData_Rain cursor for
select StartTime,No_50_f,No_51_f,No_52_f,No_53_f,No_54_f,No_55_f,No_56_f,No_57_f,No_58_f,No_59_f,No_60_f,No_61_f
from YZ_RealRain
order by StartTime asc
-- open it
open AppointData_Rain
select @cur_rowCount=@@cursor_rows
-- no data return
if @cur_rowCount<1
begin
print @cur_rowCount
end
结果总是返回的-1,而我直接用游标里面的查询语名进行查询,是能查到数据的。