摘要:
如何判断游标是否存在?--检验全局游标cur的存在性,局布的为local,如果存在就删除 if cursor_status('global','cur')<>-3 begin closecur deallocate cur end定义游标Declare s_cur cursor for select IDFROM CriterionClassify 打开游标OPEN s_curFETCH NEXT FROM s_cur into @rows循环结果集WHILE @@FETCH_STATUS = 0BEGINexec UP_CriterionClass 阅读全文