getallstudents.sql

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

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

GO

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

*/
AS
SELECT T_Student.StudentName, T_Student.StudentNO, T_Student.Gender, 
      T_Student.Birthday, T_Class.ClassName, T_Student.ClassId, T_Student.Status, 
      T_Student.Remark, T_Student.StudentId
FROM T_Student INNER JOIN
      T_Class ON T_Student.ClassId = T_Class.ClassId
WHERE (T_Student.States = 1) AND (T_Class.States = 1)

GO

/*
GRANT EXEC ON GetAllStudents TO PUBLIC

GO
*/