存储过程

CREATE DATABASE Person  --建立数据库
GO
USE Person     --打开数据库
GO
CREATE TABLE Student
(
 sId char(4) primary key, --学号（主健）
 sName varchar(50),
 sGender char(2),
 sAge int,
 sRemark varchar(100)
)
GO
INSERT INTO Student(sId,sName,sGender,sAge,sRemark) VALUES('8001','张三','男','20','班长')
INSERT INTO Student(sId,sName,sGender,sAge,sRemark) VALUES('8002','李四','女','20','学生')
INSERT INTO Student(sId,sName,sGender,sAge,sRemark) VALUES('8003','王五','男','19','学生')
INSERT INTO Student(sId,sName,sGender,sAge,sRemark) VALUES('8004','赵六','女','20','学生')
INSERT INTO Student(sId,sName,sGender,sAge,sRemark) VALUES('8005','陈七','女','19','学生')
INSERT INTO Student(sId,sName,sGender,sAge,sRemark