Stored Procedure

[sujitopics]

Hi,
I have a sql query like this.
i am using sql server 2000.

select eno, ename, sal from emp where eno='10'

how can i write stored procedure for this above query.
if anybody knows about stored procedure please give me help.
Thanksin advance
Yours
Suji

 

[vishnuprasad]

create procedure sp_GetEmployeeDetails
@Eno int,
@Eno int output,
@EName Varchar(30) output,
@Sal Decimal(12,2) output,
as

select @Eno=eno, @Ename=ename, @Sal=sal from emp where eno=@Eno
return

Just check for syntax as I have not run this in sql.

 

[vishnuprasad]

create procedure sp_GetEmployeeDetails
@Eno int,
@Eno int output,
@EName Varchar(30) output,
@Sal Decimal(12,2) output
as

select @Eno=eno, @Ename=ename, @Sal=sal from emp where eno=@Eno
return

Just check for syntax as I have not run this in sql.

 

[sujitopics]

Dear Vishnuprasad

Thankyou VeryMuch
Your Stored Procedure is Working Fine.

Can we Create Stored Procedure in MS Access ?

I need to make use of Stored Procedures in My Java Application

Thankyou Once Again

Yours
Rajesh

 

[vishnuprasad]

I dont know much about MS Access but as far as my knowledge I dont think u have any Storedprocedure's in MSaccess.