Storedprocedures

Question

Can we call one storedprocedure to another storedprocedure.

Syed Nayab Ali · Answer

Yes Shrikant You can execute a storedprocedure into another storedprocedure. This is one of the benifits of SP. But you should know effect or result of inner SP because at the time of execution of outer SP you can't see output of inner SP. Create procedure SP1 AS BEGIN exec SP2 END Try to use code of SP2 in the body SP1 (if you have and if it is not too much long) because it will save execution time. Thanks Please click on  Accepted Answer  if it helps you

Pravin More · Answer

Hi Shrikant......... yes... you can call like that..... for e.g:- Create PROCEDURE [dbo].[testpravinnew] AS BEGIN SET NOCOUNT ON exec TestPravin param1param2 END ThanksMark it as Accepted answer if it helps you. Pravin.

Dhaval Patel · Answer

Dear sreekanth you are partially correct sp's can call another sp but the levels is only upto 32.