updatecourse.sql

一个别人编写的学生管理系统,开以看下

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'UpdateCourse')
	BEGIN
		DROP  Procedure  UpdateCourse
	END

GO

CREATE Procedure UpdateCourse
@ClassId int,
@SubjectId int,
@BeginDate datetime,
@FinishDate datetime,
@Remark varchar(256),
@CourseId int
AS
UPDATE T_Course
SET ClassId = @ClassId, BeginDate = @BeginDate, SubjectId = @SubjectId, 
      FinishDate = @FinishDate, Remark = @Remark
WHERE (CourseId = @CourseId)

GO

/*
GRANT EXEC ON UpdateCourse TO PUBLIC

GO
*/