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

Information Technology, What benefits can a company gain by managing its ow... What benefits can a company gain by managing its own information infrastructure and servicea

List the table modification commands in sql, List the table modification co... List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

Explain physical and logical independence, Define Physical and Logical inde... Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Explain the concept of data mining, Question 1 Explain the concept of Fore... Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

Explain outer join, Explain outer join? Outer Join - If there are any... Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro

In e-r diagram how generalization is represented, In E-R diagram how genera... In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

Job scheduling strategy, 1) Define a job scheduling strategy that will meet... 1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Illustrate the deployment diagram, Illustrate the Deployment Diagram A... Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

What are the objectives of query processing, What are the objectives of que... What are the objectives of query processing?       Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien

E - r schema with weak entity, Consider the E/R schema with weak entity set... Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include