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
- 18727 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 are the different kinds of ssrs reports?
What is tcl in sql server?
How can you list all the columns in a database?
Benefits of Stored Procedures?
What are the different types of collation sensitivity?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is the stuff and how does it differ from the replace function?
How will you know when statistics on a table are obsolete?
What is an expression in ms sql server?
Can you always create a cache of a report?
What command is used to delete a table from the database in the sql server and how?
List out the differences between global and local temp tables in sql server?
What are the advantages of having an index on the sql server?
Why does sql studio use a single registered database repository? : sql server management studio
Please explain what is “asynchronous” communication in sql server service broker?
