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
- 18740 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
what is isolation level at dead lock?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Is it important for a database administrator to understand the operating system and file access?
What are the character string functions supported by sql server 2005?
Please illustrate physical database architecture? : SQL Server Architecture
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the default fill factor value?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What are different backups available in sql server?
Explain in brief how sql server enhances scalability of the database system?
What is the web service used for reporting services?
How to use union to merge outputs from two queries together in ms sql server?
Can we take the full database backup in log shipping?
List some major differences between triggers and stored procedures?
How do I find the transaction log size in sql server?
