Sql 游标样例 

DECLARE mycur CURSOR FOR SELECT id FROM table
OPEN mycur  --打开游标
FETCH NEXT FROM mycur INTO @schemeId
WHILE @@FETCH_STATUS = 0
BEGIN        

    FETCH NEXT FROM mycur INTO @schemeId
END
CLOSE mycur
    DEALLOCATE mycur

 

posted @ 2020-04-13 10:40  GenLang  阅读(121)  评论(0)    收藏  举报