學(xué)籍管理系統(tǒng)課程設(shè)計(jì)報告-免費(fèi)閱讀
【正文】 建立存儲過程 CREATE PROCEDURE [insert_class_1] (Class_id [varchar](50), Class_department [varchar](50), Class_college [varchar](50), Class_teacherid [varchar](50), Class_name [varchar](50)) AS INSERT INTO [sms].[dbo].[class] ([Class_id], [Class_department], [Class_college], [Class_teacherid], [Class_name]) VALUES (Class_id, Class_department, Class_college, Class_teacherid, Class_name) GO CREATE PROCEDURE [insert_course_1] (Course_id [varchar](50), Course_name [varchar](50), Course_period [int], Course_credit [int], Course_kind [int], Course_describe [varchar](50)) AS INSERT INTO [sms].[dbo].[course] ([Course_id], [Course_name], [Course_period], [Course_credit], [Course_kind ], [Course_describe]) VALUES (Course_id, Course_name, Course_period, Course_credit, Course_kind, Course_describe) GO CREATE PROCEDURE [insert_student_1] (Student_id [varchar](50), Student_name [varchar](50), Student_sex [char](5), Student_nation [char](5), Student_birthday [char](10), Student_time [char](10), Student_classid [varchar](50), Student_home [varchar](50), Student_else [varchar](50)) AS INSERT INTO [sms].[dbo].[student] ([Student_id], [Student_name], [Student_sex], [Student_nation], [Student_birthday], [Student_time], [Student_classid], [Student_home], [Student_else]) VALUES (Student_id, Student_name, Student_sex, Student_nation, Student_birthday, Student_time, Student_classid, Student_home, Student_else) GO CREATE PROCEDURE [insert_teacher_1] (Teacher_id [varchar](50), Teacher_name [varchar](50), Teacher_college [varchar](50)) AS INSERT INTO [sms].[dbo].[teacher] ([Teacher_id], [Teacher_name], [Teacher_college]) VALUES (Teacher_id, Teacher_name, Teacher_college) GO CREATE PROCEDURE [select_class_1] (Class_id [varchar](50) )
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號-1