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

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 inner join in sql server joins?

0 Answers  


What are the source of constraints?

0 Answers  


If no size is defined while creating the database, what size will the database have?

0 Answers  


can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  


what is a stored procedure and trigger?

3 Answers  






Tell me what is normalization? Explain different forms of normalization?

0 Answers  


Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  


What is the default sql server instance name?

0 Answers  


Does hive support indexing?

0 Answers  


How do clustered indexes store data?

0 Answers  


What is the difference between value type and reference type?

0 Answers  


How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,


Categories