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
This site is designed to help BCA MCA student to develop final project and synopsis Download Free BCA Project, MCA Project, IT Projects, Final report and Project synopsis with Full documentation and code
Free download MCA projects in ASP.NET with complete source code, Free download MCA projects in VB,NET with complete source code, Free download MCA MSc projects in C#.net with complete source code,
Free download MCA projects in JAVA with complete source code, Free download MCA projects in PHP with complete source code, Free download BSc CS IT projects in PHP,JAVA, ASP.NET with source code
Computer Science Final Project , Free download MCA projects in asp.net , Free download MCA projects in vb.net, Free download MCA projects in C#.net, Free download MCA projects in java, Free download MCA projects in PHP