Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
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
how to invoke a trigger on demand? : Sql server database administration
Explain system views?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the new features are introduced in sql server 2012 reporting services?
Write the syntax for stuff function in an sql server?
Can group functions be used in the order by clause in ms sql server?
How to delete duplicate rows from table except one?
Do you know the policy based administration feature of sql server 2008?
What is for xml in sql server?
between cast and convert which function would you prefer and why?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Can a table have 2 foreign keys?
What is the difference between char, varchar and nvarchar?
Can you explain what is the use of custom fields in report?
What do you understand by mirroring and mention the advantages of the mirroring?