February 9, 2010 at 10:43 pm
How many recursive call is possible in sp and udf....
Is it possible to write a sp within another sp,udf within another udf,udf in sp,sp in udf....
February 10, 2010 at 12:24 am
Please check BOL and Google before asking.
From BOL:
User-defined functions can be nested; that is, one user-defined function can call another. The nesting level is incremented when the called function starts execution, and decremented when the called function finishes execution. User-defined functions can be nested up to 32 levels. Exceeding the maximum levels of nesting causes the whole calling function chain to fail.
Each time a stored procedure calls another stored procedure or executes managed code by referencing a common language runtime (CLR) routine, type, or aggregate, the nesting level is incremented. When the maximum of 32 is exceeded, the transaction is terminated.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply