updatescore.sql

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

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

GO

CREATE Procedure UpdateSocre
@StudentId int,
@CourseId int,
@Score float,
@ScoreId int
AS
UPDATE T_Score
SET StudentId = @StudentId, CourseId = @CourseId, Score = @Score
WHERE (ScoreId = @ScoreId)

GO

/*
GRANT EXEC ON UpdateSocre TO PUBLIC

GO
*/