Next Chapter 20 Stored Procedure

CREATE PROCEDURE insStudent

(

@cENo char(10),

@cFName char(10),

@cLName char(10),

@cProgram char(10),

@cCourse char(10),

@iStudyCenCode int,

@vLoginName varchar(40),

@vpasswd varchar(40)

)

AS

insert into Student values (@cENo,@cFName ,@cLName ,@cProgram ,@cCourse ,@iStudyCenCode ,@vLoginName,@vpasswd )

GO

CREATE PROCEDURE checkStudentLogin

(

@vLoginName varchar(40),

@vPassword varchar(40),

@Yes_No int OUTPUT,

@iStuId int OUTPUT

)

AS

select @Yes_No=count(*) from Student where vLoginName=@vLoginName AND vPassword =@vPassword

select @iStuId=iStuId from Student where vLoginName=@vLoginName AND vPassword =@vPassword

RETURN

GO

CREATE PROCEDURE insExamDeptAdmin

(

@cLoginName char(20),

@vPassword varchar(40)

)

AS

Insert into ExamDept values(@cLoginName ,@vPassword )

RETURN