Explain about recursive stored procedures?
Submitted by: AdministratorRecursive 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
Submitted by: Administrator
Read Online Stored Procedure Job Interview Questions And Answers
Top Stored Procedure Questions
| ☺ | Explain about the case statement present in Stored procedure? |
| ☺ | State the different extensions for stored procedures? |
| ☺ | Explain about the RETURN statement? |
| ☺ | Explain about the implementation of stored procedures? |
| ☺ | Explain about cursors? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
