教務(wù)網(wǎng)絡(luò)管理系統(tǒng)-資料下載頁
2025-04-12 12:58本頁面
【正文】 t into student (student_id, student_name, sex, birth, class_id, entrance_date, home_addr)values(@student_id,@student_name,@sex,@birth,@class_id,@entrance_date,@home_addr)go/*向book表插入數(shù)據(jù)*/create procedure book@book_id char(13),@book_name varchar(30),@publish_pany varchar(50),@author nvarchar(8),@price numeric(5,2)asdelete from book where book_id=@book_idinsert into book(book_id,book_name,publish_pany,author,price)values(@book_id,@book_name,@publish_pany,@author,@price)go/*向class表插入數(shù)據(jù)*/create procedure class@class_id char(6),@monitor nvarchar(8),@classroom varchar(13),@student_num smallint,asdelete from class where class_id=@class_idinsert into class(class_id,monitor,classroom,student_num)values(@class_id,@monitor,@classroom,@student_num)go/*向teacher表插入數(shù)據(jù)*/create procedure teacher@teacher_id char(9),@teacher_name nvarchar(8),@sex bit,@birth smalldatetime,@department_id char(6),@profession nvarchar(16),@telephone nvarchar(15),@home_addr nchar(40),@ postalcode postalcode,asdelete from teacher where teacher_id=@teacher_idinsert into teacher(teacher_id,teacher_name,sex,birth,department_id,profession,telephone,home_addr,postalcode)values(@teacher_id,@teacher_name,@sex,@birth,@department_id,@profession,@telephone,@home_addr,@postalcode)go/*向course表插入數(shù)據(jù)*/create procedure course@course_id char(10),@course_name nvarchar(20),@book_id char(13),@total_perior tinyint,@week_perior tinyint,@credit tinyintasdelete from course where course_id=@course_idinsert into course(course_id,course_name,course_name,book_id,total_perior,week_perior,credit)values(@course_id,@course_name,@course_name,@book_id,@total_perior,@week_perior,@credit)go/*向class_course表插入數(shù)據(jù)*/create procedure class_course@class_id char(6),@course_id char(10)asdelete from class_course where class_id=@class_id and course_id=@course_idinsert into class_course(class_id,course_id)values(@class_id,@course_id)go/*向student_course表插入數(shù)據(jù)*/create procedure student_course@course_id char(10),@student_id char(8),@grade tinyint,@credit tinyint,@semester bit,@school_year char(9),asdelete from student_course where course_id=@course_id and student_id=@student_idinsert into student_course(course_id,student_id,grade,credit,semester,school_year)values(@course_id,@student_id,@grade,@credit,@semester,@school_year)go/*向teacher_course_class表插入數(shù)據(jù)*/create procedure teacher_course_class@teacher_id char(9),@course_id char(10),@class_id char(6),@semester bit,@school_year char(9),@course_schedule varchar(50),@course_classroom varchar(13)asdelete from teacher_course_class where teacher_id=@teacher_id and course_id=@course_id and class_id=@class_idinsert into teacher_course_class(teacher_id,course_id,class_id,semester,school_year,course_schedule,course_classroom)values(@teacher_id,@course_id,@class_id,@semester,@school_year,@course_schedule,@course_classroom)go
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1