Can a stored procedure call itself, Database Management System

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







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
Related Questions
How external/conceptual mapping and conceptual /internal mapping is performed

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 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

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 Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

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

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 After Reading this part, you should be able to: Explain the term CONCURRENCY; Describe the term transaction and concurrent transactions; Talk about co

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

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