数据库存储过程

Create Database StudyQutionDB
go
use StudyQutionDB
go
create table Grade
(
Id int primary key identity,
Name varchar(50),
Remark varchar(200)
)

Create table Team
(
Id int primary key identity,
Name varchar(50),
GradeId int foreign key references Grade(Id),
StuCount int,
Remark varchar(200)
)
Create table Student
(
Id int primary key identity,
Name varchar(50),
Birthday DateTime,
QQ varchar(50),
WeiXin varchar(50),
Telphone varchar(50),
Addr varchar(200),
Contacts varchar(50),
ContactPhone varchar(50),
TeamId int foreign key references Team(Id)
)
go

create proc AddGrade
(
@Name varchar(50),
@Remark varchar(50)
)
as 
begin 
insert into Grade values (@Name,@Remark)
end 
go

Create proc GetGrade
as 
begin 
select * from Grade
end 
go 

Create proc DelGrade
(
@Id int
)
as 
begin 
delete from Grade where Id = @Id 

end 
go 
Create proc UpdateGrade
(
@Id int,
@Name varchar(50),
@Remark varchar(50)
)
as 
begin 
update Grade set Name = @Name ,Remark = @Remark where Id = @Id 
end 
go 


Create proc GetGradeById
(
@Id int
)
as 
begin 
select * from Grade where Id=@Id
end 
go