Yes, you can call a stored procedure from another. SQL Server supports
also recursion in stored procedure. But, be aware of the nesting level,
is 32. For more information refer BOL(Books OnLine). Search for
create procedure, stored procedures.
/* simple procedure returning a string */
create procedure sp_example1
select 'Hello, world'
/* stored procedure which calls another one */
create procedure sp_example2
/* call the first procedure */
> 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.