Stored Procedure page 3

CREATE PROCEDURE checkExpertLogin

(

@vLoginName varchar(40),

@vPassword varchar(40),

@Yes_No int OUTPUT,

@ExpertId int OUTPUT

)

AS

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

select @ExpertId =iExId from Expert where vLoginName=@vLoginName AND vPassword =@vPassword

RETURN

GO

CREATE PROCEDURE insObjQAttempted

(

@iStuId int,

@iObjQusId int,

@chAns char(10)

)

AS

Insert into SubQAttempted values(@iStuId ,@iObjQusId ,@chAns)

RETURN

GO

CREATE PROCEDURE insObjQues

(

@iExId int,

@tObjQus text,

@cOptionA char(10),

@cOptionB char(10),

@cOptionC char(10),

@cOptionD char(10),

@cAns text,

@bStatus bit

)

AS

insert into ObjQus (iExId, tObjQus, cOptionA, cOptionB, cOptionC, cOptionD, cAns, bStatus)

values (@iExId,@tObjQus,@cOptionA,@cOptionB,@cOptionC,@cOptionD,@cAns,@bStatus)

GO

CREATE PROCEDURE insResult

(

@iStuId int,

@iMarkOfSub int,

@iMarkOfObj int,

@chStatus char(10)

)

AS

Insert into Result(iStuId , iMarkOfSub ,chStatus ) values(@iStuId ,

@iMarkOfSub , @chStatus )

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 documentation, Free download MCA projects in VB.NET with documentation, Free download MCA BSc CS projects in C#.NET with documentation,

Free download MCA projects in JAVA with documentation, Free download MCA projects in PHP with documentation, Free Download MCA BTech BE MSc BSc IT CS projects in PHP with MY SQL

Free Download BCA Final Year Project Synopsis, Free Download BCA Final Year Project Report, Free Download MCA Final Year Project Synopsis, Free Download MCA Final Year Project Report