Nesting Stored Procedures

Rohatash Kumar

14y4.2k

Hi all,

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anil Kumar14y ago
Accepted 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.
0
Rohatash Kumar14y ago
Thanks Anil,

When we use Nested Stored Procedures in sql server?
0
Anil Kumar14y ago

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

0
Satyapriya Nayak14y ago
http://www.informit.com/articles/article.aspx?p=25288&seqNum=12

http://www.java2s.com/Tutorial/SQLServer/0420__Procedure-Function/NestingStoredProcedures.htm
0