deletestudent.sql

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

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

GO

CREATE Procedure DeleteStudent
@StudentId int
AS
UPDATE T_Score
SET States = 0
WHERE (StudentId = @StudentId)
UPDATE T_Student
SET States = 0
WHERE (StudentId = @StudentId)

GO

/*
GRANT EXEC ON DeleteStudent TO PUBLIC

GO
*/