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

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

How to optimize stored procedures in sql server?

0 Answers  

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

what is difference between primary key and Unique

8 Answers  

What is the largest component inside a field?

0 Answers  

How to create a user name in a database?

0 Answers  

Explain the difference between function and stored procedure?

0 Answers  

How to encrypt data between dialogs?

0 Answers  

What are .mdf files?

0 Answers  

What is difference between equi join and inner join?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories