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
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