insertstudent.sql

一个别人编写的学生管理系统,开以看下

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

GO

CREATE Procedure InsertStudent
@StudentNO varchar(20),
@StudentName varchar(50),
@Gender bit,
@Birthday datetime,
@ClassId int,
@Status int = 1,
@Remark varchar(256)
AS
INSERT INTO T_Student
      (StudentNO, StudentName, Gender, Birthday, ClassId, Status, Remark)
VALUES (@StudentNO,@StudentName,@Gender,@Birthday,@ClassId,@Status,@Remark)

GO

/*
GRANT EXEC ON InsertStudent TO PUBLIC

GO
*/