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

Explain in brief how sql server enhances scalability of the database system?

0 Answers  

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

What are joins in sql and what are the different types of joins?

0 Answers  

List the different types of joins?

0 Answers  

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

What is explicit cursors?

0 Answers  

what is the difference between procedure and function.

4 Answers   Thomson,

Explain what is log shipping?

0 Answers  

Anyone please explain me the concept of Serialization?

3 Answers  

What is extent? Types of extents?

0 Answers  

What is primary key and example?

0 Answers  

What does the automatic recovery do?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories