getallclasses.sql

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

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

GO

CREATE Procedure GetAllClasses
/*
	(
		@parameter1 int = 5,
		@parameter2 datatype OUTPUT
	)

*/
AS
SELECT ClassId, ClassName, EntranceDate, Remark
FROM T_Class
WHERE (States = 1)

GO

/*
GRANT EXEC ON GetAllClasses TO PUBLIC

GO
*/