Can we call Stored Procedure in Other Stored Procedure???

Question

Hi Can any one tell me is it possible to call one stored procedure inside other stored procedure??? If some one know its answer then please let me know. Thanks in advance.

Vijaya Kadiyala · Answer

Hi yes it possible but make sure that you dont cross the nested level of the stored procedure. the nested level is 32. Thanks --Vj

abhishek trivedi · Answer

Hi !! This is possible and simple as well. you have to write Exec provedure name and write the parameter value to pass into the second procedure. that's it. You will get the second SP executing inside the First one.

Martin · Answer

Yes it is as long as the user that is logged in has access to the stored procedure being called within the stored procedure. Simply 'exec' it within the stored procedure.