--删除小课堂段信息

                   delete from uu_MinClassroomSect

                   where min_classroom_id = @miniClassroom_id

                   --删除小课堂用户购买记录

                   delete from uu_UserBuyMinClassroom

                   where min_classroom_id = @miniClassroom_id

                   --删除对应小课堂年级学科信息

                   delete from uu_MinClassroomToGradeClass

                   where min_classroom_id = @miniClassroom_id

                   --删除小课堂发言

                   delete from uu_MinClassroomDiscuss

                   where min_classroom_id = @miniClassroom_id

                   --删除课程讨论

                   DELETE FROM uu_CourseDiscuss

                   WHERE course_id IN

                      (SELECT course_id

                      FROM uu_CourseInfo

                      WHERE min_classroom_id = @miniClassroom_id)

                   --删除用户课程收藏

                   DELETE FROM uu_UserCellectionCourse

                   WHERE course_id IN

                      (SELECT course_id

                      FROM uu_CourseInfo

                      WHERE min_classroom_id = @miniClassroom_id)

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9]  下一页