Very Computer

Hi all

I'm using Sqlserver 2000 .
I would like to know if it is possible to call a stored procedure from
another stored procedure . I'm not in the master database .
If the answer is true would you mind guiving me the syntax.

Thanks for the help in advance.

Hi,
Yes, you can call a stored procedure from another. SQL Server supports
also recursion in stored procedure. But, be aware of the nesting level,
which
is 32. For more information refer BOL(Books OnLine). Search for
create procedure, stored procedures.
Good Luck

use pubs
go

/* simple procedure returning a string */
create procedure sp_example1
as

select 'Hello, world'
go

/* stored procedure which calls another one */
create procedure sp_example2
as
/* call the first procedure  */
exec sp_example1

go

exec sp_example2

Quote:> Hi all

> I'm using Sqlserver 2000 .
> I would like to know if it is possible to call a stored procedure from
> another stored procedure . I'm not in the master database .
> If the answer is true would you mind guiving me the syntax.

> Thanks for the help in advance.

Wassim,

One executes a stored procedure by prefacing it with EXECUTE, for example
...

create procedure spWassim_1 as
 exec spWassim_2
go

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Quote:> Hi all

> I'm using Sqlserver 2000 .
> I would like to know if it is possible to call a stored procedure from
> another stored procedure . I'm not in the master database .
> If the answer is true would you mind guiving me the syntax.

> Thanks for the help in advance.