Calling a stored procedure in another stored procedure in SQL Server 7.0

SAID LAACHRAT

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Calling a stored procedure in another stored procedure in SQL Server 7.0

Hello, I'm an ACCESS user and I'm migrating an ACS Database to SQL
SERVER. I want to create a S.P. (A) that uses another S.P. (B). In
Access, you just use the name of the S.P. A as if it was a TABLE, it
appears that in SQL S, it is not the case. I tried to add them
parameters like SELECT * FROM A(@1,@2) but it does not work either,
could you please help me ???

Thanks a lot

Habib

Mohame

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Calling a stored procedure in another stored procedure in SQL Server 7.0

Quote

SAID LAACHRATE <laachr...@freesurf.fr> wrote in message

news:3854C2B4.C741E588@freesurf.fr...

Quote

> Hello, I'm an ACCESS user and I'm migrating an ACS Database to SQL
> SERVER. I want to create a S.P. (A) that uses another S.P. (B). In
> Access, you just use the name of the S.P. A as if it was a TABLE, it
> appears that in SQL S, it is not the case. I tried to add them
> parameters like SELECT * FROM A(@1,@2) but it does not work either,
> could you please help me ???

> Thanks a lot

> Habib

Hi Habib

you can do that like :

Declare @InputParam Int,
@OutPutParam Int

Select @InputParam=...
EXECUTE MyStoredProc @InputParam , @OutPutParam OUTPUT

Mohamed

BPMargoli

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Calling a stored procedure in another stored procedure in SQL Server 7.0

Habib,

create table t ( ... )
go

insert into t
exec A @P1, @P2

select * from t

This requires that you know the output of the stored procedure ahead of time
so that you can create table t to hold the result set of the stored
procedure.

Quote

SAID LAACHRATE <laachr...@freesurf.fr> wrote in message

news:3854C2B4.C741E588@freesurf.fr...

Quote

> Hello, I'm an ACCESS user and I'm migrating an ACS Database to SQL
> SERVER. I want to create a S.P. (A) that uses another S.P. (B). In
> Access, you just use the name of the S.P. A as if it was a TABLE, it
> appears that in SQL S, it is not the case. I tried to add them
> parameters like SELECT * FROM A(@1,@2) but it does not work either,
> could you please help me ???

> Thanks a lot

> Habib

Other Threads

1. SQL Server 7.0 with Delphi 5.0 - stored procedures with parameters - Native BDE driver

2. Delphi 5.0 + SQL Server 7.0 + Stored Procedure

3. Stored Procedure - Sql Server 7.0

4. MS SQL Server 7.0 stored procedure

5. SQL Server 7.0 Could Not find Stored Procedure

6. Delphi 4 and SQL Server 7.0 Stored procedures

7. Problem calling SQL Server stored procedure

8. Problem of return value when calling stored procedure in MS SQL Server

9. Problem calling SQL Server stored procedure

10. Stored Procedure - Passing Argument in to a Stored Procedure