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
- 18652 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
Explain how dts is used to extract, transform and consolidate data?
How to enter date and time literals in ms sql server?
What are the kinds of subquery?
Explain the benefits of user-defined functions?
If a stored procedure is taking a table data type, how it looks?
What is format parameter in ssrs?
What is sparse columns of sql server 2008?
What is difference between commit and rollback when used in transactions?
Difference between LEN() and DATALENGTH() in sql server ?
what is difference between view and Dip.
What is report rendering ?
How many triggers are possible per table?
what purpose does the model database serve? : Sql server database administration
What is an entity-relationship diagram (erd)?
How to download and install microsoft sql server management studio express?
