Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
- 2 Answers
- 18932 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why and when do stored procedure recompile?
Can we do dml on views?
How to convert character strings into numeric values?
Can one drop a column from a table?
do you know how to configure db2 side of the application? : Sql server database administration
When should you use an instead of trigger?
Why use identity in sql server?
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?
Can sql servers link to other servers like oracle?
What is in place upgrade in sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Disadvantages of the indexes?
What are the properties of the transaction?
How to enter binary string literals in ms sql server?
How to remove duplicate rows from table except one?
