Interested to Buy Any Domain ? << Click Here >> for more details...
Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
- 2 Answers
- 18797 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 |
What is a recursive stored procedure in sql server?
What is the difference between a local and a global temporary table?
What command do we use to rename a database?
What are the triggers in sql?
What are SQL Jobs, please mention the use of it and how to create them.
What happens to a trigger with multiple affected rows?
What are various aggregate functions that are available?
What are the differences between having and where clause.
How to return the top 5 rows from a select query in ms sql server?
Wht is Stuff in sql ser
What do you mean by cardinality?
What is Schema? and why we use schemas?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
