游标 实例

    DECLARE    @C_GYOU        VARCHAR(6)

    DECLARE CUR_GYOU CURSOR FOR
    SELECT C_GYOU FROM #TMP_S36
    
    OPEN CUR_GYOU
    FETCH NEXT FROM CUR_GYOU INTO @C_GYOU
    WHILE @@FETCH_STATUS=0
    BEGIN
    END
    CLOSE CUR_GYOU
    DEALLOCATE CUR_GYOU