deletescore.sql

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

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

GO

CREATE Procedure DeleteScore
@ScoreId int
AS
UPDATE T_Score
SET States = 0
WHERE (ScoreId = @ScoreId)

GO

/*
GRANT EXEC ON DeleteScore TO PUBLIC

GO
*/