文件名称：创建存储过程-tomcat服务器图片地址中文路径问题解决办法
文件大小：3.07MB
文件格式：PDF
更新时间：2024-06-29 13:33:25
信息管理
5.3 创建存储过程 5.3.1 插入信息 5.3.1.1 插入学生基本信息 create proc usp_InsertStuInfor @Sno varchar(10),@Sname varchar(10),@Ssex char(2),@Sage int,@Sphone char(11),@Sborndate nvarchar(50),@SdepartId int,@SclassId int,@Saddress nvarchar(50),@isDel bit = 0,@Sstartschool nvarchar(50),@SgradeId int as insert into StudentInfor values(@Sno,@Sname,@Ssex,@Sage,@Sphone,@Sborndate,@SdepartId,@SclassId,@Saddress, @isDel,@Sstartschool,@SgradeId) 5.3.2.2 插入班级信息 create proc usp_InsertClassInfor @ClassId int ,@ClassName nvarchar(20),@isDel bit = 0, @TeacherId int as insert into ClassInfor values(@ClassId,@ClassName,@isDel,@TeacherId) 5.3.2.3 插入成绩信息 create proc usp_InsertScoreInfor @Sno varchar(10) ,@ScourseId int,@Score decimal(5, 2),@isDel bit = 0 as insert into ScoreInfor values(@Sno,@ScourseId,@Score,@isDel) 5.3.2.4 插入课程信息 create proc usp_InsertCourseInfor @CourseId int ,@CourseName nvarchar(20),@CourseTeacherId int,@CourseCredit decimal(3, 1),@isDel bit = 0 as insert into CourseInfor values(@CourseId,@CourseName, @CourseTeacherId,@CourseCredit,@isDel)