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
- 18868 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 the difference between getdate and sysdatetime?
Can a table have 2 primary keys?
What is fill factor and pad index?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is normalization of database? What are its benefits?
What are sql azure firewall rules?
What is a trigger what are the advantages of trigger?
What is forward - only cursors / read only cursor?
What are the limitations/drawbacks or ssrs 2008 r2?
What is a scheduled job or what is a scheduled task?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How many columns can we include on clustered index ?
How to how to convert numeric expression data types using the convert() function??
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
