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