Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
Answers were Sorted based on User's Feedback
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 |
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 |
What is inner join in sql server joins?
What are the source of constraints?
If no size is defined while creating the database, what size will the database have?
can we call functions from stored procedure in SQL Server 2005 ? How?
what is a stored procedure and trigger?
Tell me what is normalization? Explain different forms of normalization?
Can you link only other SQL Servers or any database servers such as Oracle?
What is the default sql server instance name?
Does hive support indexing?
How do clustered indexes store data?
What is the difference between value type and reference type?
How can u get the number of pupils connecting the database?