deleteclass.sql

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

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

GO

CREATE Procedure DeleteClass
@ClassId int
AS

UPDATE T_Student
SET States = 0
WHERE (ClassId = @ClassId)
UPDATE T_Course
SET States = 0
WHERE (ClassId = @ClassId)
UPDATE T_Score
SET States = 0
WHERE (StudentId in (Select StudentId from T_Student where ClassId = @ClassId))
UPDATE T_Class
SET States = 0
WHERE (ClassId = @ClassId)
GO

/*
GRANT EXEC ON DeleteClass TO PUBLIC

GO
*/