Stored Procedure Question:
Explain about recursive stored procedures?
Answer:
Recursive stored procedures are used for performing repetitive tasks. Recursive feature is disabled by default but can be activated by using the following command on the server max_sp_recursion_depth, also don’t forget to rename the system variable to a non zero variable.
| Previous Question | Next Question |
| Explain the benefits of running stored procedure on a database engine? | Explain about the process which takes place to execute a Stored routine? |