Stored Procedure Question:
Download Job Interview Questions and Answers PDF
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.
Download Stored Procedure Interview Questions And Answers
PDF
| 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? |