Stored Procedure Interview Question:

Explain about recursive stored procedures?

Submitted by: Administrator

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.
Submitted by: Administrator