What do you understand by recursive stored procedure?
- 1 Answers
- 1041 Views
- I also Faced
- E-Mail Answers
Answer Posted / Tulika Chatterjee
A recursive stored procedure is a stored procedure that calls itself repeatedly to process hierarchical data or iterative tasks. It has at least one RECURSIVE common table expression (CTE) in its definition, which defines the base case and the recursive case for the procedure.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to rebuild the master database?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Why we use the openxml clause?
Can one drop a column from a table?
What are the properties of the transaction?
What is a view in sql?
What are different types of constraints?
How raid can influence database performance?
How do I find the sql server version?
What is in place upgrade in sql server?
What are the source of constraints?
Explain “row_number()” in sql server with an example?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Equi join and non equi join is possible with sql server?
What is sql server query analyzer?
