What do you understand by recursive stored procedures?
devquora
Posted On: Feb 22, 2018
Repetitive tasks are being performed by the recursive stored procedures. By default this function is disabled but can be activated using a particular command. The command is as follows-
Max_sp_recursion_depth;
After using this, the system variable should be renamed to a non-zero variable.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Stored Procedures Interview Questions
What do you understand by a stored procedure?
The group of SQL statements which are or have been stored in the server database is known as a stored procedure. Input ..
Stored Procedures Interview Questions
Mention the uses of stored procedures.
Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:Stored p..
Stored Procedures Interview Questions
What are the types of stored procedures in an SQL server?
The types of stored procedures present in an SQL server are listed as follows: – User-defined stored procedures– th..