Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?

Question Posted / guest

Answers were Sorted based on User's Feedback



Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?..

Answer / 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

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?..

Answer / lipsa

If a procedure calls itself it is called recursive.
Like if we are calculating the factorial of a number
writing a stored procedure,then there will be recursive
calling of the procedure.

Is This Answer Correct ?    19 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What are the advantages of using stored procedures?

0 Answers  

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

How to join two tables in a single query in ms sql server?

0 Answers  

Is resultset an interface?

0 Answers  

Can we hide the definition of a stored procedure from a use?

0 Answers  

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

what is difference between nchar and char in Sql server ?

3 Answers  

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

What are the types of containers in ssis?

0 Answers  

How to write character string constants or literals in ms sql server?

0 Answers  

What is a fill factor?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories