top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Recursice Stored Procedure!

+2 votes
295 views

Can a Stored Procedure call itself or a Recursive Stored Procedure? How many levels of SP nesting is possible?

posted Aug 22, 2014 by Muskan

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
 
Best answer

you can write stored procedures that call themselves.
Recursion can be defined as a method of problem solving wherein the solution is arrived at by repetitively applying it to subsets of the problem. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps.
Stored procedures are nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate.
You can nest stored procedures and managed code references up to 32 levels

answer Aug 28, 2014 by Amit Kumar Pandey
Similar Questions
0 votes

I have a number of INSERT and UPDATE statements in a MySQL Stored Procedure, that works in the form of START TRANSACTION followed by COMMIT. Also I am handling any EXCEPTION.

However, after calling COMMIT, how can I get the number of Rows that were affected either INSERTED or UPDATTED ?

...