sql server 游标fetch简单用法

//遍历tmp_check的年份和月份DECLARE @year as varchar(4)DECLARE @month as varchar(2)DECLARE cur CURSOR FOR SELECT nf,yf FROM tmp_check;OPEN cur fetch next from cur into @year,@monthwhile(@@fetch_status=0)beginPRint(@year)print(@month)//在这做其它的事fetch next from cur into @year,@monthend close cur DEALLOCATE cur