Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
- 2 Answers
- 18238 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
Tell me what is the stuff and how does it differ from the replace function?
Explain what are various ways to enhance the ssrs report?
Where are full-text indexes stored?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the types of ssrs?
What is 5nf in normalization form?
Can group functions be used in the order by clause in ms sql server?
What is 4nf in normalization form?
What is a cache in ssrs?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
how many layers of tcp/ip protocol combined of? : Sql server database administration
Describe in brief databases and sql server databases architecture.
State a few properties of relational databases?
What is public role in sql server?
What are the differences between stored procedure and the dynamic sql?
