Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

Yes we can stored procedure call itself or recursive stored procedure. Because Stored procedures is basically are  nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate. we can nest stored procedures and managed code references up to 32 levels. T-SQL supports recursion, we can write the stored procedures because of call, Recursion have a techniques or methods of problem solving, Where in the solution is applying o the problems it can be use of subset of problems only. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps. 

By:UMANG
Date:2010-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher