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 can you manage sql azure security?
Define cursor locking
Explain candidate key, alternate key, and composite key?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
How to create percentile function?
What is difference between stored procedure and user defined function?
explain the storage models of olap? : Sql server database administration
What is proper subset of candidate key?
What is ddl command?
Is sql server free?
What are exact numeric data types in ms sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is temporal data type?
query processing
how many type of indexing in database?