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

Why do we need different type of parameter?

0 Answers  

What is a Lock and let me know Different types of locks?

2 Answers  

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

What is the maximum size of column in sql server?

0 Answers  

What is the simplest way to create a new database in ms sql server?

0 Answers  




Which are ddl commands?

0 Answers  

How do you set a trace flag in sql server?

0 Answers  

How can I create a table from another table without copying any values from the old table?

3 Answers  

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

How to rebuild all indexes on a single table?

0 Answers  

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

What is Index ? Explain its Types?

2 Answers   ADP,

For more SQL Server Interview Questions Click Here
Categories