updatestudent.sql

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

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

GO

CREATE Procedure UpdateStudent
@StudentNO varchar(20),
@StudentName varchar(50),
@Gender bit,
@Birthday datetime,
@ClassId int,
@Status int = 1,
@Remark varchar(256),
@StudentId int
AS
UPDATE T_Student
SET StudentNO = @StudentNO, StudentName = @StudentName, Gender = @Gender, 
      Birthday = @Birthday, ClassId = @ClassId, Status = @Status, 
      Remark = @Remark
WHERE (StudentId = @StudentId)

GO

/*
GRANT EXEC ON UpdateStudent TO PUBLIC

GO
*/