游标

DECLARE LearningStatu_cursor CURSOR--定义一个游标
FOR
    SELECT  EnrollmentID
    FROM    LMS.Enrollment
    WHERE   CourseID = @CourseID;  
OPEN LearningStatu_cursor;
DECLARE @Enrollmentid INT;
FETCH NEXT FROM LearningStatu_cursor INTO @Enrollmentid;

WHILE @@fetch_status = 0
    BEGIN 
        IF ( @Enrollmentid IS NOT NULL )
            BEGIN
                INSERT  INTO LMS.LearningStatu
                        ( EnrollmentID ,
                          --字段
                        )
                VALUES  ( @Enrollmentid , 
                        ---字段值
                        );

                FETCH NEXT FROM LearningStatu_cursor INTO @Enrollmentid;

               --为每一个注册的注册编号进行循环

            END;
    END;
CLOSE LearningStatu_cursor;
DEALLOCATE LearningStatu_cursor;