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

Mapping, How external/conceptual mapping and conceptual /internal mapping i... How external/conceptual mapping and conceptual /internal mapping is performed

Explain dynamic two-phase locking, Explain Dynamic Two-Phase Locking H... Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item.  After finishing all the operations on

Create student db and retrieve all student name in cs, Create a Student dat... Create a Student database and Retrieve the names of all students majoring in ‘CS' Consider the following relational database: STUDENT (name, student#, class, major) COURSE (co

Develop a simple database of student records, In this programming assignmen... In this programming assignment, you will develop a simple database of student records. Here are the requirements: 1) A student record contains a name and a number. We assume tha

Database recovery and security, Database Recovery And Security Introdu... Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

ER diagrams, explain exhaustively the problems associated with ER diagrams.... explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

Should i select imaging software that allows changes, Should I select imagi... Should I select imaging software that allows changes? An imaging system should not give features to edit or alter images. Images generally are formed as safe and secure records

Objectives-transactions and concurrency management, Objectives After Re... Objectives After Reading this part, you should be able to: Explain the term CONCURRENCY; Describe the term transaction and concurrent transactions; Talk about co

What you understand by client-server environment, Problem: a) Briefly d... Problem: a) Briefly describe what you understand by Client-Server environment b) The File Server is a simple form of Client-Server. Describe the principles of the File Serve

Higher software development cost, Drawbacks of Data Distribution: The prim... Drawbacks of Data Distribution: The primary drawbacks of distributed database systems are the added complexity needed to ensure proper coordination between the sites. This increas