insertclass.sql

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

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

GO

CREATE Procedure InsertClass
@ClassName varchar(50),
@EntranceDate datetime,
@Remark varchar(256)
AS
INSERT INTO T_Class
      (ClassName, EntranceDate, Remark)
VALUES (@ClassName,@EntranceDate,@Remark)

GO

/*
GRANT EXEC ON InsertClass TO PUBLIC

GO
*/