实战SQL语句收集(不断更新中--)

                   --删除小课堂段信息

                   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]  下一页

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18