Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

Yes. Because Transact-SQL supports recursion, you can write kept procedures that call themselves. Recursion can be explained as a method of problem solving wherein the solution is arrived at by repetitively applying it to subsets of the problem. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps. Stored procedures are nested when one kept procedure calls another or implements managed code by referencing a CLR routine, type, or aggregate. You can nest kept procedures and managed code references up to 32 levels.

 

Posted Date: 7/10/2013 6:21:19 AM | Location : United States

Ask an Expert

Related Discussions:- Can a stored procedure call itself, Assignment Help, Ask Question on Can a stored procedure call itself, Get Answer, Expert's Help, Can a stored procedure call itself Discussions

Write discussion on Can a stored procedure call itself
Your posts are moderated

Write your message here..

Related Questions

Determine the concept of process, Determine the concept of Process Pro... Determine the concept of Process Process: A process transforms the data values. It is represented as ellipse containing a description of transformation. Each procedure has a

ERD DIAGRAM, Law Associates is a large legal practice based in Sydney. You... Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs

Example of transaction? , Example :; transfers transfer_amount from x's acc... Example :; transfers transfer_amount from x's account to y's account ; Supposes x&y both accounts exist TRANSACTION (x, y, transfer_amount) Start transaction IF X AND Y

Entity integrity constraint - relational constraints, It defines that no pr... It defines that no primary key value can be null. This is as the primary key is used to recognize individual tuple in the relation. So we will not be able to recognize the records

Explain object oriented model, Explain Object oriented Model ? Object ... Explain Object oriented Model ? Object Oriented Model - This model is based on the object-oriented programming language paradigm. It involves the features of OOP such as inhe

What is serializability, What is serializability? Explain its types? Th... What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.

Define hot backup, Hot Backup: Some sites cannot terminate the database wh... Hot Backup: Some sites cannot terminate the database while creating a backup copy of the files. The cold backup is not a reliable option. So different kinds of backing up database

Creating views with replace option, Creating views with Replace option : Th... Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

Which method is used to key transformation, Which method is used to key tra... Which method is used to key transformation ? A hash method is used to key transformation.

What are composite objects, What are composite objects? Objects that ha... What are composite objects? Objects that have other objects are known as complex objects or composite objects.