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. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |