getstudentsbyclassid.sql

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

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

GO

CREATE Procedure GetStudentsByClassID
@ClassId int
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.ClassId = @ClassId) AND (T_Student.States = 1) AND 
      (T_Class.States = 1)

GO

/*
GRANT EXEC ON GetStudentsByClassID TO PUBLIC

GO
*/