insertscore.sql

来自「一个别人编写的学生管理系统,开以看下」· SQL 代码 · 共 25 行

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

GO

CREATE Procedure InsertScore
@CourseId int,
@StudentId int,
@Score float
AS

INSERT INTO T_Score
      (CourseId, StudentId, Score)
VALUES (@CourseId,@StudentId,@Score)
GO

/*
GRANT EXEC ON InsertScore TO PUBLIC

GO
*/