updateclass.sql

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

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

GO

CREATE Procedure UpdateClass
@ClassName varchar(50),
@EntranceDate datetime,
@Remark varchar(256),
@ClassId int
AS
UPDATE T_Class
SET ClassName = @ClassName, EntranceDate = @EntranceDate, 
      Remark = @Remark
WHERE (ClassId = @ClassId)

GO

/*
GRANT EXEC ON UpdateClass TO PUBLIC

GO
*/