Nesting Stored Procedures

Question

Hi all When we use Nested Stored Procedures in sql server. How to execute it.

Anil Kumar · Answer

There may be many reasons for using Nested stored procedures like you want to call stored procedures from a parent stored procedure based on certain condition. When a stored procedure is get called from a stored procedure it comes in context of Nested stored procedure.The nest level increases each time a stored procedure calls another and stopped when nesting level 32 reached. It is used to break huge level of SQL code into smaller pieces.And it helps to find the mistakes if any and in modifications.

Rohatash Kumar · Answer

Thanks Anil When we use Nested Stored Procedures in sql server?

Anil Kumar · Answer

http://msdn.microsoft.com/en-us/library/ms190607(v=sql.105).aspx execute examples can be seen here : http://msdn.microsoft.com/en-us/library/ms187371(v=sql.105).aspx

Satyapriya Nayak · Answer

http://www.informit.com/articles/article.aspx?p=25288&seqNum=12 http://www.java2s.com/Tutorial/SQLServer/0420__Procedure-Function/NestingStoredProcedures.htm