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
- 18775 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
When would you use sql joins?
What do you mean by subquery?
How to drop an existing table?
How to recreate an existing index in ms sql server?
What stored procedure can you use to display the current processes?
What is a join in sql? What are the types of joins?
What is the default value of an integer data type in sql server 2005?
What is a recursive stored procedure in sql server?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Characterize join and name diverse sorts of joins?
Why use identity in sql server?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What are the default system databases in sql server 2000?
What is identity?
What command is used to create a database in the sql server and how?
