deletesubject.sql

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

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

GO

CREATE Procedure DeleteSubject
@SubjectId int
AS

UPDATE T_Subject
SET State = 0
WHERE (SubjectId = @SubjectId)
GO

/*
GRANT EXEC ON DeleteSubject TO PUBLIC

GO
*/