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 is change data capture (cdc) in sql server 2008?

0 Answers  

How do you make a trace?

0 Answers  

How to check status of stored procedure in sql server?

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

Can we delete data from a view?

0 Answers  

What is the primary use of the model database?

0 Answers  

What is sql or structured query language?

0 Answers  

Explain what is cte (common table expression)?

0 Answers  

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories