Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
- 2 Answers
- 18239 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 types of upgrades that can be performed in sql server?
What are the benefits and tasks of object explorer? : sql server management studio
What is transact-sql ddl trigger?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How many types of attribute relationships are there? : sql server analysis services, ssas
What are the types of processing and explain each? : sql server analysis services, ssas
What is 1nf 2nf?
What xml support does the sql server extend?
What is the rdl file?
How to get @@error and @@rowcount at the same time?
Define Joins?
What is an inner join?
How to create new databases with "create database" statements?
what is a mixed extent? : Sql server administration
What is the difference between clustered and a non-clustered index?
