Call SQL Server 2000 Stored Procedure with in and out parameter

[Sanjeev]

Hello Gurus,

I have following Stored Procedure defined in the SQL Server 2000
database.

CREATE Procedure GetEmpDetails
(
@fromdate varchar(25),
@todate varchar(25)
)
as
Begin
select empno,
ename,
sal,
managerID
from emp
where hiredate between @fromdate and @todate
End

The above Stored Procedure returns more than one rows.
I have to wirte JDBC code which uses Callable Statement.

Could anyone provide me the source code for the same.

Thanks in advance

Regards
Sanjeev
(e-mail address removed)

 

[GArlington]

Hello Gurus,

I have following Stored Procedure defined in the SQL Server 2000
database.

CREATE Procedure GetEmpDetails
(
@fromdate varchar(25),
@todate varchar(25)
)
as
Begin
select empno,
ename,
sal,
managerID
from emp
where hiredate between @fromdate and @todate
End

The above Stored Procedure returns more than one rows.
I have to wirte JDBC code which uses Callable Statement.

Could anyone provide me the source code for the same.

Thanks in advance

Regards
Sanjeev
(e-mail address removed)

How about "java call stored procedure" on google?