Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
- 2 Answers
- 18231 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhu
When one stored procedure calls another stored procedure
(SP) you have what is called stored procedure nesting. We
can have recursive stored procedures upto 32 nest levels.
| Is This Answer Correct ? | 29 Yes | 2 No |
Answer / lipsa
If a procedure calls itself it is called recursive.
Like if we are calculating the factorial of a number
writing a stored procedure,then there will be recursive
calling of the procedure.
| Is This Answer Correct ? | 19 Yes | 3 No |
Do you know what is difference between index seek vs. Index scan?
Should you normalize audio?
What is best institute to Learn DotNET And SQL in chennai?
What is the use of tempdb? What values does it hold?
Is it possible to update the views? If yes, how, if not, why?
Explain about system stored procedure?
What stored procedure can you use to display the current processes?
How do we rollback the table data in SQL Server
How to check table values in sql server?
How use inner join in sql server?
Explain what is raid and what are different types of raid levels?
What is Replication?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
