Stored Procedure page 2

GO

CREATE PROCEDURE checkExamDept

(

@vLoginName varchar(40),

@vPassword varchar(40),

@Yes_No int OUTPUT,

@iExamDeptId int OUTPUT

)

AS

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

select @iExamDeptId =iExamDeptId from ExamDept where vLoginName=@vLoginName AND vPassword =@vPassword

RETURN

GO

CREATE PROCEDURE insExpert

(

@cFName char(20),

@cLname char(20),

@cCourse char(20),

@vLoginName varchar(40),

@vPassword varchar(40)

)

AS

Insert into Expert values(@cFName, @cLname , @cCourse , @vLoginName, @vPassword )

RETURN

GO