为表添加，更改记录，创建存储过程的例子

--为课程表添加一条记录
create proc courseInsert
@courseId int,
@courseName nvarchar,
@courseIntro nvarchar,
@term int,
@credit float,
@IscourseExam nvarchar,
@courseType nchar
as
begin
set nocount on;
insert into dbo.Course (courseId,courseName,courseIntro,term,credit,IscourseExam,courseType) values (@courseId,@courseName,@courseIntro,@term,@credit,@IscourseExam,@courseType)
end
go

--更新课程表
crea