insertcourse.sql

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

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

GO

CREATE Procedure InsertCourse
@ClassId int,
@SubjectId int,
@BeginDate datetime,
@FinishDate datetime,
@Remark varchar(256)
AS
INSERT INTO T_Course
      (ClassId, SubjectId, BeginDate, FinishDate, Remark)
VALUES (@ClassId,@SubjectId,@BeginDate,@FinishDate,@Remark)

GO

/*
GRANT EXEC ON InsertCourse TO PUBLIC

GO
*/